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

ORA-30016: undo tablespace 'string' is already in use by this instance

1 Answers

ORA-02310: exceeded maximum number of allowable columns in table

1 Answers

ORA-08266: create_ora_addr: cannot register name in nameserver

1 Answers

ORA-30053: invalid upper limit snapshot expression

1 Answers

ORA-23371: column string unknown in table string

1 Answers

ORA-39002: invalid operation

1 Answers

NZE-29233: the key object could not be encoded

1 Answers

ORA-16708: The state supplied to resource guard is invalid.

1 Answers

TNS-12548: TNS:incomplete read or write

1 Answers

DRG-12700: seed word must be a single word

1 Answers

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

1 Answers

RMAN-06022: invalid level specified for image copy: number

1 Answers

For more Oracle Errors Interview Questions Click Here