ORA-22900

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

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

Acción: Change the subquery to SELECT a nested table or VARRAY item.