CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_WARNING_INTERNAL

Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/prvtplsw.plb
First Availability 10.1
Dependencies
warning_settings$ dba_warning_settings
all_warning_settings user_warning_settings
 
SHOW_WARNING_SETTING

Undocumented ... and obviously not intended for DBAs and developers

dbms_warning_internal(objno IN NUMBER)
RETURN dbms_warning_internal.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
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;

 
Related Topics
DBMS_WARNING
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [203 users online]    © 2010 psoug.org