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