Skip to Main Content

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!

ORA-02291: integrity constraint violated - parent key not found

cpAug 9 2012 — edited Aug 9 2012
I have a row in parent table. I am using the same sequence from the parent table during insertion. (In fact I am getting the sequence from the drop down during insertion in plsql developer tool). Still I am getting this error.

1) Parent table's primary key is Child table's primary key as well as foreign key.
2) Parent table's primary key is referred as primary key in some other child table as well.
3) But not using Supertype-Subtype relationship. Just direct reference

Can you please tell me why am I getting this error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2012
Added on Aug 9 2012
8 comments
34,469 views