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 *


PIERO

PIERO

E

NEED BULK COLLECT

gelete

gelete

E.

Error at line 42
ORA-06550: line 14, column 35:
PLS-00642: local collection types not allowed in SQL statements

14 SELECT last_name INTO v_last_names FROM employees