Oracle DBMS_WARNING_INTERNAL Demos

Oracle DBMS_WARNING_INTERNAL Version 11.2.0.3

General Information

Purpose

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

AUTHID

CURRENT_USER

Dependencies

ALL_WARNING_SETTINGS	USER_WARNING_SETTINGS	WARNING_SETTINGS$
DBA_WARNING_SETTINGS

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 warning_setting_coll;

conn uwclass/uwclass

ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';

CREATE OR REPLACE PROCEDURE dead_code AS
x NUMBER := 10;
BEGIN
IF x = 10 THEN
x := 20;
ELSE
x := 100;
END IF;
END dead_code;
/

SELECT plsql_warnings
FROM all_plsql_object_settings
WHERE name = 'DEAD_CODE';

conn / as sysdba

SELECT object_id
FROM dba_objects_ae
WHERE object_name = 'DEAD_CODE';

SELECT COUNT(*)
FROM dba_warning_settings;

set linesize 121

SELECT owner, object_id, object_type
FROM dba_warning_settings
WHERE object_name = 'DEAD_CODE';

SELECT dbms_warning_internal.show_warning_settings(71895)
FROM dual;

desc dba_warning_settings

SELECT *
FROM dba_warning_settings
WHERE object_id = 71895;