Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reference error

999406May 16 2013 — edited May 16 2013

I am trying to enter data into a table that also has a nested table. This is the error that I am getting:

SQL Error: ORA-22979: cannot INSERT object view REF or user-defined REF 22979. 00000 - "cannot INSERT object view REF or user-defined REF" Cause: Attempt to insert an object view REF or user-defined REF in a REF column created to store system generated REF values" Action: Make sure the REF to be inserted is not from an object view or from a user-defined REF column

Can I please have an explanation as to why this is occurring and how to fix it.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2013

Added on May 16 2013

#general-database-discussions

3 comments

301 views