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!

violated - child record found

Prabhakar KDec 21 2016 — edited Dec 25 2016

Hi Masters,

I have proc on purge. when I execute the proc, I got the below error.

ERROR at line 1:

ORA-02292: integrity constraint (abc.FK_POLICYRESULTSUMMARY_POLI_1)

violated - child record found

ORA-06512: at "abc.HDM_CLEANUP_UTIL", line 351

ORA-06512: at line 6

I did some ground work .. which table as child records. But how to write a select query to see child records are found in the table. (Table A, Table B) common column is ID for both tables. (which is not null column)

I am using oracle 11g. (11.2.0.2). on delete cascade is useful. But I have to check why this error has come? somebody made some mess. Please help me.

Please advise...!!!

Regards

Frd

This post has been answered by Cookiemonster76 on Dec 22 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2017

Added on Dec 21 2016

21 comments

3,053 views