ORA-22905: cannot access rows from a non-nested table item

You are here: Home // Oracle 11g // ORA-22905: cannot access rows from a non-nested table item

Cause: attempt to access rows of an item whose type is not known at parse time or that is not of a nested table type See the solution below.

Error solution: use CAST to cast the item to a nested table type

Database version: Oracle 11g Release 2 (11.2)