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>