Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
View the Exhibit and examine the PL/SQL code.
You compile the program with the following attributes:
SQL> ALTER PROCEDURE proc1 COMPILE PLSQL_OPTIMIZE_LEVEL = 1;
Which statement is true about the execution of the PROC1 procedure in this scenario?
A.
The FUNC1 function would be called inline because PRAGMA INLINE forces a specific call to
be inlined.
B.
The FUNC1 function would be inlined because the value set for the PLSQL_CODE_TYPE
parameter is set to NATIVE.
C.
The FUNC1 function would be called inline irrespective of the value set for the
PLSQL_OPTIMIZE_LEVEL parameter.
D.
The FUNC1 function would not be called inline because the value for the
PLSQL_OPTIMIZE_LEVEL parameter is set to a lower value.
D