ORA-22900: the SELECT list item of THE subquery is not a collection type

ORA-22900: the SELECT list item of THE subquery is not a
collection type

Question Posted / guest

1 Answers
3570 Views
I also Faced
E-Mail Answers

ORA-22900: the SELECT list item of THE subquery is not a collection type..

Answer / guest

Cause: The THE subquery must SELECT a nested table or VARRAY
item.

Action: change the subquery to SELECT a nested table or
VARRAY item.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00440: Database ID for database string changed to number.

1 Answers

NNL-00287: Cache flush occurs in string

1 Answers

DRG-12406: invalid CTX EXEC tag attribute (string)

1 Answers

RMAN-08055: media recovery complete

1 Answers

RMAN-06421: sent command to channel: string

1 Answers

ORA-13463: error retrieving GeoRaster data: string

1 Answers

DGM-17002: Primary database can not be removed.

1 Answers

PCC-02347: PL/SQL found syntax errors

1 Answers

ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers

ORA-25403: could not reconnect

1 Answers

ORA-28174: Kerberos ticket not provided by proxy

1 Answers

ORA-07495: spwat: lm_wait failed.

1 Answers

For more Oracle Errors Interview Questions Click Here