ALTER SESSION SET plsql_optimize_level = 3 

ALTER SESSION SET plsql_warnings='enable:all' 

CREATE OR REPLACE PROCEDURE show_inlining  
   AUTHID DEFINER  
IS  
   FUNCTION f1 (p NUMBER)  RETURN PLS_INTEGER  
   IS  
   BEGIN  
      RETURN p * 10;  
   END;  
  
   FUNCTION f2 (p BOOLEAN) RETURN PLS_INTEGER  
   IS  
   BEGIN  
      RETURN CASE WHEN p THEN 10 ELSE 100 END;  
   END;  
  
   FUNCTION f3 (p PLS_INTEGER) RETURN PLS_INTEGER  
   IS  
   BEGIN  
      RETURN p * 10;  
   END;  
BEGIN  
   DBMS_OUTPUT.put_line ('f1 called: ' || f1 (1));  
  
   PRAGMA INLINE (f2, 'YES');  
   DBMS_OUTPUT.put_line ('f2 called: ' || TO_CHAR (f2 (TRUE) + f2 (FALSE)));  
  
   PRAGMA INLINE (f3, 'NO');  
   DBMS_OUTPUT.put_line ('f3 called: ' || f3 (55));  
END; 

BEGIN 
   show_inlining; 
END;