Hi all,

I'm using Squirrel and Oracle plugin together with the ojdbc6.jar driver. I could correctly create a packaged stored procedure that has 3 parameters (2 varchar IN and a refcursor OUT). The procedure works fine as I can correctly call it from other tools than Squirrel ... and I do get the correct data.

However I'm not able to display the value returned from Squirrel, here is the code I'm using :

Code:
declare
TYPE refcur IS REF CURSOR;
v refcur;
begin
scott.mypack.myproc ('100','dd',v);
end;/
What I can't find is where to place a command (and which command ?) in order to display the value of v. Does anybody have an idea ?

Thank you very much !