Enable All Deprecation Compilation Warnings
ALTER SESSION SET PLSQL_WARNINGS='ENABLE:(6019,6020,6021,6022)'
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;