Oracle PL/SQL Tutorial/SQL PLUS Session Environment/plsql ccflags

ALTER SESSION SET 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