Oracle PL/SQL/System Packages/DBMS TRACE

DBMS_TRACE.PLSQL_TRACE_VERSION

   <source lang="sql">

SQL> SQL> set serveroutput on SQL> SQL> DECLARE

 2    v_MajorVersion BINARY_INTEGER;
 3    v_MinorVersion BINARY_INTEGER;
 4  BEGIN
 5    DBMS_TRACE.PLSQL_TRACE_VERSION(v_MajorVersion, v_MinorVersion);
 6    DBMS_OUTPUT.PUT_LINE("Trace major version: " || v_MajorVersion);
 7    DBMS_OUTPUT.PUT_LINE("Trace minor version: " || v_MinorVersion);
 8  END;
 9  /

Trace major version: 1 Trace minor version: 0 PL/SQL procedure successfully completed. SQL> SQL>

</source>
   
  

Enable tracing of all calls and all exceptions.

   <source lang="sql">

SQL> BEGIN

 2    DBMS_TRACE.SET_PLSQL_TRACE(
 3      DBMS_TRACE.TRACE_ALL_CALLS +
 4      DBMS_TRACE.TRACE_ALL_EXCEPTIONS);
 5  END;
 6  /

PL/SQL procedure successfully completed. SQL> SQL> SQL>

</source>