Oracle PL/SQL - Displaying Values of PL/SQL Compilation Parameters

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Statement
  4. Preprocessor Control Tokens

Introduction

The following code displays the current values of PL/SQL the compilation parameters.

Demo

SQL>
SQL> BEGIN-- from   w w  w .ja v a  2 s  . c  o m
  2    DBMS_OUTPUT.PUT_LINE('$$PLSCOPE_SETTINGS = '     || $$PLSCOPE_SETTINGS);
  3    DBMS_OUTPUT.PUT_LINE('$$PLSQL_CCFLAGS = '        || $$PLSQL_CCFLAGS);
  4    DBMS_OUTPUT.PUT_LINE('$$PLSQL_CODE_TYPE = '      || $$PLSQL_CODE_TYPE);
  5    DBMS_OUTPUT.PUT_LINE('$$PLSQL_OPTIMIZE_LEVEL = ' || $$PLSQL_OPTIMIZE_LEVEL);
  6    DBMS_OUTPUT.PUT_LINE('$$PLSQL_WARNINGS = '       || $$PLSQL_WARNINGS);
  7    DBMS_OUTPUT.PUT_LINE('$$NLS_LENGTH_SEMANTICS = ' || $$NLS_LENGTH_SEMANTICS);
  8  END;
  9  /
$$PLSCOPE_SETTINGS =
$$PLSQL_CCFLAGS =
$$PLSQL_CODE_TYPE = INTERPRETED
$$PLSQL_OPTIMIZE_LEVEL = 2
$$PLSQL_WARNINGS = DISABLE:ALL
$$NLS_LENGTH_SEMANTICS = BYTE

PL/SQL procedure successfully completed.

SQL>

Related Topic