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.
ORA-22900: the SELECT list item of THE subquery is not a collection type
The THE subquery must SELECT a nested table or VARRAY item.
change the subquery to SELECT a nested table or VARRAY item.