$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print <<

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
EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>