PL/SQL Packages DBMS_DEBUG

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

Related:


 
Copyright © 1999-2024 SS64.com
Some rights reserved