Enable tracing of all calls and all exceptions. : DBMS_TRACE « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_TRACE

Enable tracing of all calls and all exceptions.

 
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>

 

Related examples in the same category