Hey there folks…noob to the forum, and hoping some here may be able to help.
I’m attempting to test a packaged procedure through SQL Nav 5.5. I’ve successfully retrieved sets of “simple”, single-value OUT parameters, both in the message window with DBMS_OUTPUT checked and in the execution interface with DBMS_OUTPUT unchecked.
I’ve been able to return a REF CURSOR result from a procedure when it is the only OUT parameter of a proecedure by unchecking DBMS_OUTPUT and expanding the result in the execution console/interface.
What I’m running into now is a bit more complex.
The procedure in question returns five OUT parameters. Two are varchar2 (100), One is CLOB, one is a REF CURSOR and one is a TYPE TABLE Object (custom defined record structure).
Running the procedure with DBMS_OUTPUT returns the varchar and CLOB parameters, but doesn’t display the TYPE or REF CURSOR content. Unchecking “DBMS_OUTPUT” causes errors/failures in content return.
How do I view this complex set of outputs from a single procedure in SQL Navigator?