No debug information in "Test Window"

[Torsten Liermann]

(sorry, I can not speak english ...)

Im testing the trial version of PL/SQL Developer an I'm missing the debug information in the test window, when the mouse is over a variable ("no debug information"). Is anywhere a prereferences like "compile with debug"?

Thanks for a help

 

[William Robertson]

Yes, right-click on the procedure/function/package name and you will see an "Add debug information" option.

 

[ScottMattes]

And, you can NOT debug the code displayed in the Test Window. If you want to do that you need to make the code in the Test Window into a Stored Procedure and then make a Test Window to call that SP. It is an Oracle limitation.

 

[axmz]

Is possible to have debug information in a window test to even test program pl/sql that is not going away to store?

 

[William Robertson]

As I understand it PL/SQL Developer's debugger is an interface to Oracle's DBMS_DEBUG package which resides in the database and interfaces with stored PL/SQL.