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

Oracle Error Message

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

Reason for the Error

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

Solution

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