Oracle PL/SQL Tutorial/SQL PLUS Session Environment/PLSQL DEBUG

Reference environment parameter in procedure

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.