December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_TRACE.SET_PLSQL_TRACE
(trace_level IN INTEGER);
Sets trace_level to either 1, which traces all lines (TRACE_ALL_LINES), or 2, which only traces lines in enabled program units (TRACE_ENABLE_LINES).
PROCEDURE DBMS_TRACE.CLEAR_PLSQL_TRACE;
Disables the existing PL/SQL trace.
PROCEDURE DBMS_TRACE.PLSQL_TRACE_VERSION
(major OUT BINARY_INTEGER,
minor OUT BINARY_INTEGER);
Returns the version of the current PL/SQL trace utility.