What could be the reason?

View Exhibit1 and examine the structure of the EMPLOYEES table.

View Exhibit2 and examine the code in the PL/SQL block.
The PL/SQL block fails to execute.
What could be the reason?

View Exhibit1 and examine the structure of the EMPLOYEES table.

View Exhibit2 and examine the code in the PL/SQL block.
The PL/SQL block fails to execute.
What could be the reason?

A.
Nested tables cannot be returned by a function.

B.
The NEWNAMES nested table has not been initialized.

C.
The assignment operator cannot be used to transfer all the element values from GROUP1 to
GROUP2.

D.
The third element of OLDNAMES cannot be assigned to the third element of GROUP1
because they are of inconsistent data types.

E.
LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local
collection types are not allowed in SQL statements.



Leave a Reply 3

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


Marian

Marian

the same as 28

RF

RF

PLS-00642: local collection types not allowed in SQL statements

PIERO

PIERO

E

BULK COLLECT INTO IS MANDATARY