This content has been marked as final. Show 3 replies
Off the top of my head, your parameter type on the second parameter is wrong. The function doesn't have a return value, one of the parameters contains it. So the second parameter's type can't be ReturnValue (should be output).
Either that or change the function to only have one parameter and add RETURN sys_refcursor into the definition, at which point you can use ReturnValue.
Here's an example: http://stackoverflow.com/questions/1773534/what-is-the-right-way-to-call-an-oracle-stored-function-from-ado-net-and-get-the
Edited by: Tridus on Mar 20, 2013 10:24 AM
Let me clarify. This is not the actual function, its the code produced when I try to run the function from SQL Developer. Also, I am doing things as described in your example in the case of having a cursor
I actually solved the problem....Just had to put the return value parameter first instead of second