Reference environment parameter in procedure : PLSQL_DEBUG « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. PLSQL_DEBUG

SQL>
SQL> CREATE OR REPLACE PROCEDURE show_parameters
  2  IS
  3  BEGIN
  4     IF $$PLSQL_DEBUG  THEN
  5        DBMS_OUTPUT.PUT_LINE ('DEBUG ON');
  6     ELSE
  7        DBMS_OUTPUT.PUT_LINE ('DEBUG OFF');
  8     END IF;
  9     DBMS_OUTPUT.PUT_LINE ($$PLSQL_OPTIMIZE_LEVEL);
 10     DBMS_OUTPUT.PUT_LINE ($$PLSQL_CODE_TYPE);
 11     DBMS_OUTPUT.PUT_LINE ($$PLSQL_WARNINGS);
 12     DBMS_OUTPUT.PUT_LINE ($$NLS_LENGTH_SEMANTICS);
 13  END show_parameters;
 14  /

Procedure created.