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

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

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