Enable Deprecation Compilation Warnings Using the DBMS_WARNING Package
BEGIN
DBMS_WARNING.ADD_WARNING_SETTING_NUM (6019,
'ENABLE',
'SESSION');
DBMS_WARNING.ADD_WARNING_SETTING_NUM (6020,
'ENABLE',
'SESSION');
DBMS_WARNING.ADD_WARNING_SETTING_NUM (6021,
'ENABLE',
'SESSION');
DBMS_WARNING.ADD_WARNING_SETTING_NUM (6022,
'ENABLE',
'SESSION');
END;
Statement processed.
CREATE OR REPLACE PACKAGE pack2 AS
PROCEDURE proc1(n1 NUMBER, n2 NUMBER, n3 NUMBER);
PROCEDURE proc1(n1 NUMBER, n2 NUMBER);
PRAGMA DEPRECATE(proc1);
END pack2;
Warning: PACKAGE PACK2 Line: 5 PLW-06019: entity PROC1 is deprecatedMore Details: https://docs.oracle.com/error-help/db/ora-20001
CREATE OR REPLACE PROCEDURE proc5 AUTHID DEFINER AS
BEGIN
pack2.proc1(1,1);
END;
Warning: PROCEDURE PROC5 Line: 3 PLW-06020: reference to a deprecated entity: PROC1 declared in unit PACK2[4,13]More Details: https://docs.oracle.com/error-help/db/ora-20001
CREATE OR REPLACE PROCEDURE proc6 AUTHID DEFINER AS
BEGIN
pack2.proc1(1,1,1);
END;
Procedure created.
SELECT * FROM USER_ERRORS WHERE NAME IN ('PACK2','PROC5','PROC6')
NAME | TYPE | SEQUENCE | LINE | POSITION | TEXT | ATTRIBUTE | MESSAGE_NUMBER | PACK2 | PACKAGE | 1 | 5 | 7 | PLW-06019: entity PROC1 is deprecated | WARNING | 6019 | PROC5 | PROCEDURE | 1 | 3 | 3 | PLW-06020: reference to a deprecated entity: PROC1 declared in unit PACK2[4,13] | WARNING | 6020 |
---|