| 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 |
|
| Security Model |
Owned by SYS with no granted privileges |
| |
| 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; |
