How to call a stored procedure using a ref cursor on oracle with squirrel
- by rapdum
Hello,
I'm trying to do the same request i'm using in Toad
(the store proc signature is two varchar2 parameter and one REF CURSOR parameter)
Here is what I do with Toad
variable myCursor refcursor;
EXEC myproc('param1','param2',:myCursor );
print myCursor;
I don't know how to write this with Squirrel and I have to use Squirrel.
thanks a lot for your response
Raphaël