December 2002
Intermediate to advanced
928 pages
85h 29m
English
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:
ALTERunit_typeunit_nameCOMPILE DEBUG; ALTER PACKAGE | TYPEunit_nameCOMPILE 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.