The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session.
Examine the section of code given:
FUNCTION p2 (p boolean) return PLS_INTEGER IS …
FUNCTION p2 (x PLS_INTEGER) return PLS_INTEGER IS
… …
PRAGMA INLINE(p2, ‘YES’);
x := p2(true) + p2(3);
…
Which statement is true about the INLINE pragma procedure calls?
A.
Only the call to the P2 function with BOOLEAN as the argument is inlined.
B.
INLINE pragma affects both the functions named P2 and is called inline.
C.
Only the call to the P2 function with PLS_INTEGER as the argument is inlined.
D.
None of the functions are inlined because inlining is not supported for overloaded functions.
B
Example 13-2 Specifying that an Overloaded Subprogram Is To Be Inlined
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/inline_pragma.htm#LNPLS01362
if PLSQL_OPTIMIZE_LEVEL=3, then PRGAMA INLINE only impact immediate following subprogram