Request: show dbms output when executing SQL in debug window

Claus Pedersen

Member³
I would like that dbms output is shown when executing SQL in the debug window.
If the user executes a method that has output, this output should be shown, just like the Output tab in the normal SQL window.

Today, when an anonymous PL/SQL block is executed, PLD shows an info dialog with the message "Statement executed successfully". In the future, the debugger result set window should always be shown with the new Output tab, to be able to investigate the output from the PL/SQL code
 
Are you talking about the Test Window? I am running PLSD version 10 and as I step through a Stored Procedure that I executed from the Test Window I see the output from the dbms_output.put_line immediately after that line is run (i do have to click the DBMS Output tab, but the output is there immediately)
 
Hello Scott,

Thanks for your answer. Yes, I meant to refer to the test window in debug mode. Here you can execute SQL, selects/updates or PL/SQL blocks (BEGIN .. END), etc. But I am not able to see the output from this execution, for instance if I loop over a cursor and wants to see the result using dbms_output.put_line.
I can not see it on the Output window of the test window. If I use dbms_output as a part of my test code (inside a package/method or elsewhere in the test code, it works as expected.
 
Back
Top