This API is primarily intended to implement server-side debuggers and it provides a way to debug server-side PL/SQL program units.
Subprocedures and functions: PROBE_VERSION Return the version number of DBMS_DEBUG on the server. SELF_CHECK Perform an internal consistency check. SET_TIMEOUT Function Set the timeout value. INITIALIZE Function Set debugID in target session. DEBUG_ON Turns debug-mode on. DEBUG_OFF Turns debug-mode off. ATTACH_SESSION Notify the debug session about the target debugID. SYNCHRONIZE Function Wait for program to start running. SHOW_SOURCE Fetch program source. PRINT_BACKTRACE Print a stack backtrace. CONTINUE Function Continue execution of the target program. SET_BREAKPOINT Function Set a breakpoint in a program unit. DELETE_BREAKPOINT Function Delete a breakpoint. DISABLE_BREAKPOINT Function Disable a breakpoint. ENABLE_BREAKPOINT Function Activate an existing breakpoint. SHOW_BREAKPOINTS Return a listing of the current breakpoints. GET_VALUE Function Get a value from the currently-running program. SET_VALUE Function Set a value in the currently-running program. DETACH_SESSION Stops debugging the target program. GET_RUNTIME_INFO Function Return information about the current program. GET_INDEXES Function Return the set of indexes for an indexed table. EXECUTE Executes SQL or PL/SQL in the target session.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
"..an understanding of Visual Basic would be advantageous although not to a programming level." - Job Advert for an Oracle programmer