|
| Re: How to call a SQL function which returns a cursor using c# |
 |
Mon, 3 Mar 2008 12:43:03 +0000 |
See if any of these helps:
http://support.microsoft.com/kb/322160
http://download.oracle.com/docs/cd/B19306_01/win.102/b14307/OracleRefCursorClass
.htm
|
| Post Reply
|
| How to call a SQL function which returns a cursor using c# |
 |
Mon, 3 Mar 2008 14:50:06 +0000 |
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
|
| Post Reply
|
| Re: How to call a SQL function which returns a cursor using c# |
 |
Tue, 4 Mar 2008 01:20:55 +0000 |
Thanks siva for your links. i found my solution at
http://p2p.wrox.com/topic.asp?TOPIC_ID=30294
Thanks again
|
| Post Reply
|
|
|
|
|
|
|
|
|
|