Which statement is true about the INLINE pragma procedure calls?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

if PLSQL_OPTIMIZE_LEVEL=3, then PRGAMA INLINE only impact immediate following subprogram