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

DGM-16917: Unable to shut down instance "string".

1 Answers

ORA-12518: TNS:listener could not hand off client connection

1 Answers

ORA-09705: spcre: cannot initialize latch semaphore

1 Answers

ORA-08318: sllfsk: Error reading file

1 Answers

ORA-02829: No segment of the proper size is available

1 Answers

RMAN-06226: Automatic instance removed

1 Answers

TNS-00129: Internal error - Failed to create new community

1 Answers

PLS-01421: FOR UPDATE clause

1 Answers

LCD-00206: positional parameter entered after keyword [string]

1 Answers

PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

1 Answers

ORA-39081: failed to unsubscribe agent string from queue "string"

1 Answers

PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

1 Answers

For more Oracle Errors Interview Questions Click Here