Query user_plsql_object_settings : user_plsql_object_settings « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_plsql_object_settings

SQL>
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