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

NNL-00893: Similar requests received: number

1 Answers

ORA-31097: Hierarchical Index not empty

1 Answers

ORA-24186: wrong object type, could not transform message

1 Answers

ORA-30355: materialized view container does not exist

1 Answers

ORA-19659: incremental restore would advance file string past resetlogs

1 Answers

ORA-00250: archiver not started

1 Answers

ORA-31630: a job name is required to attach a job for user string

1 Answers

ORA-09770: pws_look_up: translation failure.

1 Answers

ORA-13016: specified topology [string] is invalid

1 Answers

ORA-12686: Invalid command specified for a service

1 Answers

ORA-39123: Data Pump transportable tablespace job aborted string

1 Answers

ORA-30433: 'string.string' is not a summary

1 Answers

For more Oracle Errors Interview Questions Click Here