Enable All Compilation Warnings
ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL'Statement processed.
CREATE OR REPLACE PACKAGE pack7 AUTHID DEFINER AS
PROCEDURE foo;
PRAGMA DEPRECATE (foo, 'pack7.foo is deprecated, use pack7.bar instead.');
PROCEDURE bar;
END pack7;
Warning: PACKAGE PACK7 Line: 3 PLW-06019: entity FOO is deprecatedMore Details: https://docs.oracle.com/error-help/db/ora-20001
CREATE OR REPLACE PROCEDURE proc4 AUTHID DEFINER AS
BEGIN
pack7.foo;
END;Warning: PROCEDURE PROC4 Line: 3 PLW-06020: reference to a deprecated entity: FOO declared in unit PACK7[2,13]. pack7.foo is deprecated, use pack7.bar instead.More Details: https://docs.oracle.com/error-help/db/ora-20001
SELECT * FROM USER_ERRORS WHERE NAME IN ('PACK7','PROC4')| NAME | TYPE | SEQUENCE | LINE | POSITION | TEXT | ATTRIBUTE | MESSAGE_NUMBER | PACK7 | PACKAGE | 1 | 3 | 3 | PLW-06019: entity FOO is deprecated | WARNING | 6019 | PROC4 | PROCEDURE | 1 | 3 | 3 | PLW-06020: reference to a deprecated entity: FOO declared in unit PACK7[2,13]. pack7.foo is deprecated, use pack7.bar instead. | WARNING | 6020 |
|---|