SQL & PL/SQL

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!

Merge against a table with self referential integrity constraint on it

630613Mar 26 2008 — edited Mar 26 2008

Hi All,

I am trying to merge load a table using merge statement. The table has self referential integrity on it. When I am trying to load the table with MERGE it is throwing the following error.

ORA-02291: integrity constraint (EDG.FK_DDLI_PRNT) violated - parent key not found

Where as FK_DDLI_PRNT is nothing but Foreignkey on DDLI_PRNT referencing DDLI_ID , Primary key of the same table.
But when I am loading with INSERT, records are getting inserted.

Any suggestions ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2008

Added on Mar 26 2008

4 comments

1,568 views