ORA-22900: the SELECT list item of THE subquery is not a collection type

Cause: The THE subquery must SELECT a nested table or VARRAY item.

Action: change the subquery to SELECT a nested table or VARRAY item.

Error Type: ORA

• Additional information for ORA-22900: the SELECT list item of THE subquery is not a collection type22900
Discussions and solutions for Oracle Database Error ORA-22900: the SELECT list item of THE subquery is not a collection type Developer anwers for Oracle Database Error ORA-22900: the SELECT list item of THE subquery is not a collection type FAQs for ORA-22900: the SELECT list item of THE subquery is not a collection type search others tips for ORA-22900: the SELECT list item of THE subquery is not a collection type