Adding text and image to database with C# and SQL

The following windows form application takes an input for name, age, gender, description, and an image. However when clicking the “Save Information” button the following exception error …

postgres procedure list of values

I’m trying to pass in a list of values into a Postgres 11 procedure. The query has an IN condition. How do I pass in a list of values to the procedure & then how do I use it in the query? create …

Incorrect number of arguments for PROCEDURE… from C#

I am having trouble using parameters in a stored procedure. I believe I am not passing the parameters in correctly with the C#. My code is roughly equivalent to: public static string GetCustomer(…

Calling Procedure with ‘call’ function from within P/L SQL Script Oracle

I am not able to run this simple if/then statement in oracle database. (i think it is 10.x but not sure, seems to be an issue of my sql skill not db version). Can you help me figure out how to run …

Stored procedure with string as parameters not working -SQL

In my database ‘Student_name’ is set as varchar. And the stored procedure is: ALTER PROCEDURE [dbo].[SP_STUDENT] @STUDENT_NAME NVARCHAR(MAX), AS DECLARE @columns NVARCHAR(MAX) = ”,…

Passing date to Stored Procedure in Oracle SQL error : ORA-01858

I know this question has been answered previously, and I have tried out the solution given in them without success. I have a stored procedure as below(I have removed non-essential parts) : CREATE OR …

How do I get rid of this SQL error from the end of my query when inserting within a procedure?

Not sure if this is even possible but im getting a weird error at the end of my query. Any idea why? Here is the code: CREATE OR REPLACE PROCEDURE NewUser (g_name VARCHAR, f_name VARCHAR, u_password …

select limit in sql

I wrote this query but gives me an error at line 15 (limit clause). we have 3 tables, state, email, and receiver. CREATE PROCEDURE `inbox`(IN `page_size` INT,IN `page_number` INT) BEGIN set @curr …

Contents of a folder (retrieved via stored procedure) not loading onto page

I’m running a stored procedure in order to get the contents of a folder and display them on a page. When I run the procedure I can see all of the documents that are in the folder, but on the page …

PL/SQL change value in 1 row in procedure

i do not know where the bug is. I must write the procedure where the 1 specific row will be chaned. Everytime i lunched it, wrote me: Errors: PROCEDURE RENAME_FLYTICKET Line/Col: 1/65 PLS-00103: …