DBMS_SESSION.SET_SQL_TRACE : dbms_session « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_session

SQL>
SQL> CREATE OR REPLACE PROCEDURE core_process IS
  2  BEGIN
  3     IF USER = 'PLSQL_USER' THEN
  4        DBMS_SESSION.SET_SQL_TRACE(TRUE);
  5        DBMS_OUTPUT.PUT_LINE('Tracing is turned on...');
  6     END IF;
  7     DBMS_SESSION.SET_SQL_TRACE(FALSE);
  8     DBMS_OUTPUT.PUT_LINE('Tracing is turned off.');
  9  END;
 10  /

Procedure created.

SQL>
SQL>