![Debugging PL/SQL with DBMS_DEBUG 20188367001]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Debugging PL/SQL with DBMS_DEBUG 1")
A very good instruction on the programmatic interface to Orace’s PL/SQL debug facilities. If you do not happen to have a GUI PL/SQL debugger – such as in JDeveloper or PL/SQL Developer or TOAD – or you are planning on building your own, you will find this article most useful: Debugging PL/SQL with DBMS_DEBUG. It takes you on a step by step development of a package that provides an easy interface, based on DBMS_DEBUG, for doing debugging. Note: this allows for example to run PL/SQL in one SQL*PLus session while debugging in a second SQL*Plus session.
About The Author
Lucas Jellema
Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
How to debug stored procedure in pl/sql.