G
Guest
I'm trying to use OracleCommand.ExecuteScalar to return a single value from an Oracle stored procedure. However it return 'null' when the out parameter is a REF CURSOR, and 'Nothing' when the out parameter is a Number.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry Pisk
Execute scalar doesn't return the value of output parameters (it does update
them but that's not the return value), it returns the first column in the
first row of the returned recordset.
Jerry
parameter is a REF CURSOR, and 'Nothing' when the out parameter is a Number.
them but that's not the return value), it returns the first column in the
first row of the returned recordset.
Jerry
from an Oracle stored procedure. However it return 'null' when the outsmay said:I'm trying to use OracleCommand.ExecuteScalar to return a single value
parameter is a REF CURSOR, and 'Nothing' when the out parameter is a Number.
J
Jerry Pisk
You do not return it through parameters, you return it by running a SELECT
statement. Like this (Oracle syntax might be a little differenet):
CREATE PROCEDURE [dbo].[myproc] @input int AS
SELECT COUNT(*) FROM [dbo].
WHERE [column] = @input
Jerry
parameter do I use, REF CURSOR and NUMBER don't work?
statement. Like this (Oracle syntax might be a little differenet):
CREATE PROCEDURE [dbo].[myproc] @input int AS
SELECT COUNT(*) FROM [dbo].
Jerry
so that OracleCommand.ExecuteScalar can pick it up? What type of outsmay said:I'm new to Oracle. How do I return a "recordset" from my stored procedure
parameter do I use, REF CURSOR and NUMBER don't work?