Hi All Gurus ,
I am doing a job where the following scenario is there .
There is 1 source table (table 1)and one look up table (table 2) .
These tables are joined on a key . Now in out put i am trying to update the same look up table (table 2) putting "Update or insert records" in SQL prompt in OCI stage .
The problem i am facing is :
Error :
"jbLdIndTermFCChg..sOciibicfcPayFinder_Update: ORA-02292: integrity constraint (FC_COMP.IP_PAY_DEAL_RECORD_FK) violated - child record found"
I have even tried putting a hash file instead of table 2(look up table ). But still getting same error .
Please suggest ?
ORA - 02291 Error coming
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
ORA - 02291 Error coming
Smrutiranjan Nayak
-
- Participant
- Posts: 2
- Joined: Tue May 30, 2006 7:04 am
- Location: Chennai
Re: ORA - 02291 Error coming
Nayak,
I think the key used for lookup is different from the foreign key and you are trying to update the lookup table including the foreign key which is reffered by a child record from other table.
Thanks,
Sankaranandam. Selvaraj
I think the key used for lookup is different from the foreign key and you are trying to update the lookup table including the foreign key which is reffered by a child record from other table.
Thanks,
Sankaranandam. Selvaraj
smrutiranjannayak wrote:Hi All Gurus ,
I am doing a job where the following scenario is there .
There is 1 source table (table 1)and one look up table (table 2) .
These tables are joined on a key . Now in out put i am trying to update the same look up table (table 2) putting "Update or insert records" in SQL prompt in OCI stage .
The problem i am facing is :
Error :
"jbLdIndTermFCChg..sOciibicfcPayFinder_Update: ORA-02292: integrity constraint (FC_COMP.IP_PAY_DEAL_RECORD_FK) violated - child record found"
I have even tried putting a hash file instead of table 2(look up table ). But still getting same error .
Please suggest ?
sankaranandam. selvaraj