Calls
-
PROCEDURE DBMS_DEBUG.PROBE_VERSION(majorOUT BINARY_INTEGER,minorOUT BINARY_INTEGER)) Specifies major and minor version number of the package.
-
PROCEDURE DBMS_DEBUG.SELF_CHECK(timeoutIN BINARY_INTEGER DEFAULT 60); If this call does not return successfully in timeout seconds, an incorrect version of DBMS_DEBUG exists on the server.
-
FUNCTION DBMS_DEBUG.SET_TIMEOUT(timeoutIN BINARY_INTEGER)RETURN BINARY_INTEGER; Sets and returns the timeout in seconds.
-
FUNCTION DBMS_DEBUG.INITIALIZE(debug_session_idIN VARCHAR2 := NULL,diagnosticsIN BINARY_INTEGER := 0)RETURN VARCHAR2; Initializes debug_session_id. If no value is supplied, an ID is automatically generated. diagnostics can be either 0, for no diagnostics in the trace file, or 1, to include diagnostics. The procedure returns the session ID.
-
PROCEDURE DBMS_DEBUG.DEBUG_ON(no_client_side_plsql_engineBOOLEAN := TRUE,immediateBOOLEAN := FALSE); Turns on debugging on the server, unless the first parameter is set to FALSE. If immediate is not TRUE, the session turns on debugging at the completion of the call; otherwise, debugging starts immediately.
-
PROCEDURE DBMS_DEBUG.DEBUG_OFF; Turns debugging off.
-
PROCEDURE DBMS_DEBUG.ATTACH_SESSION(debug_session_idIN VARCHAR2,diagnosticsIN BINARY_INTEGER := 0); Notifies the debugging session about the target program. If diagnostics is not the default of 0, will generate diagnostic output.
-
FUNCTION DBMS_DEBUG.SYNCHRONIZE(run_infoOUT runtime_info,info_requestedIN BINARY_INTEGER ...