Examine the section of code taken from a PL/SQL program:
PROCEDURE p1 (x PLS_INTEGER) IS
… …
PRAGMA INLINE (p1, ‘NO’);
x:= p1(1) + p1(2) + 17; — Call 1
…
x:= p1(3) + p1(4) + 17; — Call 2
Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL
parameter is set to 3. Which two statements are true in this scenario? (Choose two.)
A.
The calls to the P1 procedure are not inlined in the section commented as Call 1.
B.
The calls to the P1 procedure might be inlined in the section commented as Call 2.
C.
The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
D.
The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and
Call 2.
The INLINE pragma affects only the immediately following declaration or statement, and only some kinds of statements.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/inline_pragma.htm#sthref2110
A,B
A , B