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

RMAN-12008: could not locate backup piece string

1 Answers

ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation

1 Answers

RMAN-06474: maintenance channels are not allocated

1 Answers

ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

1 Answers

AMD-00113: PROCEDURE string, invalid operation

1 Answers

ORA-29812: incorrect object name specified

1 Answers

ORA-25304: Queue Table has primary/secondary instance affinity. Cannot add buffer

1 Answers

ORA-12612: TNS:connection is busy

1 Answers

ORA-12632: Role fetch failed

1 Answers

ORA-25306: Queue table string has buffered queues. Cannot alter

1 Answers

ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.

1 Answers

ORA-12703: this character set conversion is not supported

1 Answers

For more Oracle Errors Interview Questions Click Here