How to call a SQL function which returns a cursor using c#

[kasukur]

Hi

i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c#

i have tried to call using
OracleCommand.CommandType = CommandType.StoredProcedure
OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32);
p_case_action_id.Direction = ParameterDirection.Input;
p_case_action_id.Value = intSourceID;
orlCmd5.Parameters.Add(p_case_action_id);

but it's throwing an exception saying invalid arguments or saying the function name is invalid

i even tried to call the function using CommandText rather than storedprocedure and the result is same errors

Function
--------------
FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor;

Thanks in advance
Sri

[kasukur]

Hi

i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c#

i have tried to call using

OracleCommand.CommandType = CommandType.StoredProcedure 
OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32);
p_case_action_id.Direction = ParameterDirection.Input;
p_case_action_id.Value = intSourceID;
orlCmd5.Parameters.Add(p_case_action_id);
 

but it's throwing an exception saying invalid arguments or saying the function name is invalid

i even tried to call the function using CommandText rather than storedprocedure and the result is same errors

Function
--------------
FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor;

Thanks in advance
Sri

[Plater]

I have merged your two threads, please do not double post your questions.
MODERATOR


What benefit does returning a cursor offer over returning a table with one record in it?