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

SQL*Loader-00253: DB2 partition number has no significance -- ignored

1 Answers

ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace

1 Answers

ORA-13375: the layer is of type [string] while geometry inserted has type [string]

1 Answers

ORA-27206: requested file not found in media management catalog

1 Answers

DRG-12204: error while dropping section group string

1 Answers

ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.

1 Answers

ORA-12994: drop column option only allowed once in statement

1 Answers

NNL-00237: Resetting of statistic counters is currently disabled

1 Answers

ORA-16119: building transaction at SCN string

1 Answers

ORA-09243: smsget: error attaching to SGA

1 Answers

DRG-10531: parallel parameter must be > 0

1 Answers

ORA-06317: IPA: Local maximum number of users exceeded

1 Answers

For more Oracle Errors Interview Questions Click Here