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 :
TYPE refcur IS REF CURSOR;
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 ?