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.
Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director for Fusion Middleware. Consultant, trainer and instructor on diverse areas including Oracle Database (SQL & PLSQL), Service Oriented Architecture, BPM, ADF, Java in various shapes and forms and many other things. Author of the Oracle Press book: Oracle SOA Suite 11g Handbook. Frequent presenter on conferences such as JavaOne, Oracle OpenWorld, ODTUG Kaleidoscope, Devoxx and OBUG. Presenter for Oracle University Celebrity specials.