Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-22905 – cannot access rows from a non-nested table item

Oracle Database Error Code ORA-22905 Description :

cannot access rows from a non-nested table item

Error 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

How to Solve :

use CAST to cast the item to a nested table type