Enable All Deprecation Compilation Warnings
ALTER SESSION SET PLSQL_WARNINGS='ENABLE:(6019,6020,6021,6022)'
Statement processed.
CREATE OR REPLACE PROCEDURE foo AUTHID DEFINER
IS
PROCEDURE inner_bar
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Executing inner_bar');
END;
PROCEDURE inner_foo
IS
PRAGMA DEPRECATE(INNER_FOO , 'procedure inner_foo is deprecated');
BEGIN
DBMS_OUTPUT.PUT_LINE('Executing inner_foo');
END;
BEGIN
DBMS_OUTPUT.PUT_LINE('Executing foo');
inner_bar;
END;
Warning: PROCEDURE FOO Line: 10 PLW-06022: cannot use PRAGMA DEPRECATE on this entityMore Details: https://docs.oracle.com/error-help/db/ora-20001