ORA-02291: integrity constraint violated - parent key not found
cpAug 9 2012 — edited Aug 9 2012I 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.