PRAGMA INLINE IN ORACLE

The INLINE pragma specify that a sub program call is, or is not, to be inlined. Inlining replaces a sub program call (to a sub program in the same program unit) with a copy of the called sub program.
To reiterate, with sub program inlining, Oracle will re-write our code to replace a call or calls to a sub program with the executable code of the subprogram itself.
when the INLINE pragma immediately precedes one of these statements, the pragma affects every call to the specified sub program in that statement.

• Assignment
• Call
• Conditional
• CASE
• CONTINUE WHEN
• EXECUTE IMMEDIATE
• EXIT WHEN
• LOOP
• RETURN

The INLINE pragma does not affect statements that are not in the preceding list