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

ORA-13039: failed to update spatial index for element string.string.string

1 Answers  


ORA-02242: no options specified for ALTER INDEX

1 Answers  


SQL*Loader-00949: incorrect datafile string specified for table string subpartition string

1 Answers  


RMAN-06706: could not close file: "string" (reason=string)

1 Answers  


ORA-12087: online redefinition not allowed on tables owned by "string"

1 Answers  






ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

1 Answers   Oracle,


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

1 Answers  


NNO-00264: configuration database query returned no data

1 Answers  


ORA-25205: the QUEUE string.string does not exist

1 Answers  


TNS-04008: %-25s | string

1 Answers  


ORA-00107: failed to connect to ORACLE listener process

1 Answers  


PCB-00011: DBMS=V6 no longer supported; using DBMS=NATIVE

1 Answers  


Categories