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..

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

PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or "."

1 Answers  


ORA-39080: failed to create queues "string" and "string" for Data Pump job

1 Answers  


ORA-00724: ALTER DATABASE CONVERT command has been de-supported

1 Answers  


RMAN-06206: Crosschecked string objects

1 Answers  


ORA-39050: parameter string is incompatible with parameter string

1 Answers  






ORA-31115: XDB configuration error: string

1 Answers  


RMAN-03010: fatal error during library cache pre-loading

1 Answers  


ORA-25184: column name expected

1 Answers  


ORA-03201: the group number specification is invalid

1 Answers  


PCB-00101: Could not find or open system configuration file

1 Answers  


ORA-28170: unsupported certificate version

1 Answers  


NNL-00016: cannot start server, error getting program directory's name

1 Answers  


Categories