Oracle in a Nutshell

DBMS_DEBUG

Provides an API into the PL/SQL debugger layer. To use this API, you must have two sessions active—one session for the PL/SQL code and one for the debugger. You must also enable debugging for the session with the command:

ALTER SESSION SET PLSQL_DEBUG = TRUE

and recompile the target of debugging with the commands:

ALTER unit_type 
               unit_name COMPILE DEBUG;
ALTER PACKAGE | TYPE unit_name COMPILE DEBUG BODY;

You can call the PROBE_VERSION, SELF_CHECK, and SET_TIMEOUT procedures from either session. You must call the INITIALIZE, DEBUG_ON, and DEBUG_OFF procedures from the target session. You can make all other calls from the debugging session.

This package was new with Oracle8i.