SQL>
SQL> COLUMN NAME FORMAT A30
SQL> COLUMN plsql_ccflags FORMAT A30
SQL>
SQL> ALTER SESSION SET plsql_ccflags = 'app_debug:TRUE';
Session altered.
SQL>
SQL> CREATE OR REPLACE PROCEDURE test_ccflags
2 IS
3 BEGIN
4 NULL;
5 END test_ccflags;
6 /
Procedure created.
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