This content has been marked as final. Show 4 replies
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;
Edited by: riedelme on Jan 23, 2013 7:10 AM
Thanks for your suggestion.
This whole problem is in the context of "Unit Test" featureset of Oracle SQL Developer. Hence, I don't have control on explicity declaring the ref cursor as it is managed by the unit testing framework. For the same reason, SQL* Plus setting is also not an option.
Thanks & Regards,