Which statement is true about the execution of the PL/SQL code?

View the Exhibit and examine the PL/SQL code.
Which statement is true about the execution of the PL/SQL code?

View the Exhibit and examine the PL/SQL code.


Which statement is true about the execution of the PL/SQL code?

A.
It executes successfully and displays 101 and 200000 values.

B.
The ASSIGN_VAL function generates an error during compilation because nested tables cannot be returned by functions.

C.
The SELECT statement generates an error because the nested table has not been initialized in the ASSIGN_VAL function.

D.
The ASSIGN_VAL function generates an error during compilation because the EXTEND method cannot be used with nested tables.



Leave a Reply 3

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


Tr

Tr

C

Tr

Tr

ORA-06531: Reference to uninitialized collection
ORA-06512: at “HR.ASSING_VAL”, line 5
06531. 00000 – “Reference to uninitialized collection”