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

Hi Tony,
  Thanks for your help....

 For the ON DELETE CASCADE...Can you just show me a simple example to explain this better?

Thanks again in advance,
Divya

andrewst_at_onetel.net.uk (Tony) wrote in message news:<c0e3f26e.0306230442.4f4f5c4a_at_posting.google.com>...
> 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.
Received on Tue Jun 24 2003 - 10:08:13 CEST