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