Cause: The THE subquery must SELECT a nested table or VARRAY item. See the solution below.
Error solution: change the subquery to SELECT a nested table or VARRAY item.
Database version: Oracle 11g Release 2 (11.2)
You are here: Home // Oracle 11g // ORA-22900: the SELECT list item of THE subquery is not a collection type
Tags: ora, Oracle 11g Release 2