Why can output not be viewed in SQL Nav when running with debugger enabled. Specifically when running something with ref cursors, when the debugger is enabled, it automatically enables the option to "Direct results to output" and does not allow it to be changed/disabled. This prevents the output window from showing the ref cursor results.
If the debugger option is disabled, you can uncheck "Direct results to output", and the ref cursor results come up and you can click to view it.
Is there a way to view the specific info in the ref cursor with debugger on?
6.1 and older do not support output display for complex data types like cursors, when debugger is enabled.
WORKAROUND 1:
To view this in version 6.1 and older, manually edit the code to print out each record in the cursor, in that situation.
WORKAROUND 2:
SQL Nav 6.2, should be able to display the cursor data even with debugger.
*A minor problem with this functionality was found in 6.2. When working with debugger enabled and executing the package from the BODY tab, the info won't display. Please be sure to run with debug from the SPEC tab. In this case, the cursor will display in the execution console, and it can be double clicked to display the specific data.
STATUS:
Waiting for fix in a future version of SQL Navigator for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy