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

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-13462: invalid blocking specification

1 Answers  


ORA-39024: wrong schema specified for job

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-14135: a LOB column cannot serve as a partitioning column

1 Answers  


ORA-09265: spwat: error temporarily suspending process

1 Answers  






ORA-12064: invalid refresh sequence number: string

1 Answers  


PROT-00009: Failed to open the specified import file

1 Answers  


RMAN-06210: List of Mismatched objects

1 Answers  


ORA-22287: invalid or modified directory occurred during string operation

1 Answers  


QSM-00758: the specified parameter string is not valid for workload string

1 Answers  


ORA-27477: "string.string" already exists

1 Answers  


RMAN-06511: RMAN retention policy is set to redundancy number

1 Answers  


Categories