Re: Delete child-parent records???????

traineensp_at_softcell.co.in (Divya) wrote in message news:<c343a42.0306222019.6cd519c9_at_posting.google.com>...
> I am using Oracle 8.1.4.x and have few records already stored in few
> tables that share the referential integrity property....
>
> Now there is some major error in the frontend display for which i
> want to redo the entire display for which i need to first delete those
> records....But i am unable to delete hem freom either of those
> tables...I get the error message: -
>
> Error at Line 1:
> ORA 02292: integrity constraint (NSPAPP.sys_C006184)violated -
> child record found.

You have to do one of the following:

1. delete the children BEFORE the parent
2. create the foreign key constraint with ON DELETE CASCADE; then when you delete the parent, the children are deleted automatically.