ALTER SESSION SET plsql_ccflags : plsql_ccflags « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

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

SQL>
SQL>
SQL> ALTER SESSION SET plsql_ccflags = 'app_debug:FALSE';

Session altered.

SQL>
SQL> CREATE OR REPLACE PROCEDURE test_ccflags_new
  2  IS
  3  BEGIN
  4     NULL;
  5  END test_ccflags_new;
  6  /

Procedure created.

SQL>
SQL> ALTER  PROCEDURE test_ccflags COMPILE REUSE SETTINGS;

Procedure altered.

SQL>
SQL> SELECT name, plsql_ccflags
  2    FROM user_plsql_object_settings
  3   WHERE NAME LIKE '%CCFLAGS%';

NAME                           PLSQL_CCFLAGS
------------------------------ ------------------------------
TEST_CCFLAGS                   app_debug:TRUE
TEST_CCFLAGS_NEW               app_debug:FALSE