Oracle | DBMS_WARNING

Oracle DBMS_WARNING_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal support package for PL/SQL Warnings and the DBMS_WARNING package

AUTHID CURRENT_USER

Data Types WARNING_SETTING_COLL

Dependencies

ALL_WARNING_SETTINGS	DBA_WARNING_SETTINGS	WARNING_SETTINGS$
CDB_WARNING_SETTINGS	USER_WARNING_SETTINGS

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtplsw.plb

SHOW_WARNING_SETTING

Undocumented ... and obviously not intended for DBAs and developers dbms_warning_internal(objno IN NUMBER) RETURN PIPELINED warning_setting_coll;

conn uwclass/uwclass@pdbdev

      

      ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';

      

      CREATE OR REPLACE PROCEDURE dead_code AUTHID DEFINER AS

       x NUMBER := 10;

      BEGIN

        IF x = 10 THEN

          x := 20;

        ELSE

          x := 100;

        END IF;

      END dead_code;

      /

      

      SP2-0804: Procedure created with compilation warnings

      

      SELECT plsql_warnings

      FROM all_plsql_object_settings

      WHERE name = 'DEAD_CODE';

      

      conn sys@pdbdev as sysdba

      

      SELECT COUNT(*)

      FROM dba_warning_settings;

      

       COUNT(*)

      ---------

            663

      

      set linesize 121

      

      SELECT owner, object_id, object_type

      FROM dba_warning_settings

      WHERE object_name = 'DEAD_CODE';

      

      OWNER   OBJECT_ID OBJECT_TYPE

      ------ ---------- -----------

      UWCLASS     75140 PROCEDURE

      

      SELECT 
      dbms_warning_internal.show_warning_settings(75140)

      FROM dual;

      

      DBMS_WARNING_INTERNAL.SHOW_WARNING_SETTINGS(71895)(OBJ_NO, WARNING, SETTING, PROPERTY)

      --------------------------------------------------------------------------------------

      SYS_PLSQL_9DEB8363_32_1(SYS_PLSQL_9DEB8363_9_1(75140, -4, 1, 1))

      

      

      SQL> SELECT * FROM TABLE(dbms_warning_internal.show_warning_settings(75140));

      

       OBJ_NO    WARNING SETTING PROPERTY

      ---------- ------- ------- --------

           75140      -4       1        1

      

      desc dba_warning_settings

      

      SELECT *

      FROM dba_warning_settings

      WHERE object_id = 75140;

      

      OWNER   OBJECT_NAME  OBJECT_ID  OBJECT_TYPE  WARNING SETTING

      -------- ----------- ---------- ------------ ------- -------

      UWCLASS DEAD_CODE    75140      PROCEDURE    ALL     ENABLE