Oracle PL/SQL Tutorial/System Tables Data Dictionary/user plsql object settings

Query user_plsql_object_settings

   <source lang="sql">

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</source>

SELECT owner, NAME, plsql_warnings FROM user_plsql_object_settings

   <source lang="sql">

SQL> SELECT owner, NAME, plsql_warnings

 2    FROM user_plsql_object_settings
 3   WHERE plsql_warnings LIKE "%DISABLE%"
 4     AND owner NOT IN ("SYS", "SYSTEM");
  AND owner NOT IN ("SYS", "SYSTEM")

SQL> SQL></source>