979635 wrote:Try explicity declaring the ref cursor instead of using a bind variable, something like (untested)
But, when I try to execute this Test, I get the following error:
Validation Boolean function failed: Unable to convert <oracle.jdbc.driver.OracleResultSetImpl@4f0617> to REF CURSOR.
If I run in the debug mode, I get the following content in a dialog box:
The following procedure was run.
Bind variables used
:1 NUMBER IN 1001
:2 REF CURSOR OUT (null)
Alternately, in SQL*PLUS use the DEFINE command to ste a named bind variable to type REFCURSOR and use the named bind variable in your test
begin foo sys_refcurosr; begin test_procedure(foo); end;