Adding debugging info to anonymous PL/SQL

[bobdog]

Does anyone know how to add "debugging information" to an anonymous PL/SQL block?

Thanks!

 

[Marco Kalter]

You can only set breakpoints and view/set variables in stored program units. In the anonymous PL/SQL Block of the Test Script, these things are unfortunately not possible.

As a work around you could create a dummy procedure (e.g. anonymous_block) as a placeholder for the ad hoc code snippets you wish to test. Replace its PL/SQL Block with the code you want to test, compile it, and debug it. I admit it's not ideal, but it's a work around.

------------------
Marco Kalter
Allround Automations