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