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



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

Answer / guest

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

Action: use CAST to cast the item to a nested table type

Please add more information about this Error

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file

1 Answers  


ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-00273: media recovery of direct load data that was not logged

1 Answers  


DRG-11838: Proxy Reauthentication Required

1 Answers  


ORA-24039: Queue string not created in queue table for multiple consumers

1 Answers  






NZE-29018: The premaster secret contains an incorrect version number.

1 Answers  


ORA-28659: COMPRESS must be specified at object level first

1 Answers  


ORA-28505: cannot get non-Oracle system capabilities from string

1 Answers  


EXP-00095: Flashback_time and Flashback_scn are not compatible

1 Answers  


ORA-00067: invalid value string for parameter string; must be at least string

1 Answers  


PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"

1 Answers  


QSM-01085: materialized view, string, has a lossy join between tables, string

1 Answers  


Categories