Re: Cascade Delete Help!

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 15 Mar 1999 16:29:25 GMT
Message-ID: <36ee352d.13216884@192.86.155.100>

A copy of this was sent to "Tom" <tom_at_tempus.com> (if that email address didn't require changing) On Mon, 15 Mar 1999 08:58:40 -0500, you wrote:

>I am trying to do a cascade delete and I keep getting a "Mutating Table"
>error. Without adding constraints, how do I properly set up a "delete on
>row" trigger that triggers another "delete on row" trigger?
>
>Thanks in advance
>

use the ON DELETE CASCADE option with the declaritve integrity constraint -- you must have a foreign key defined (else you would not get the mutating table error) -- just make it an 'on delete cascade' foreign key.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Mar 15 1999 - 10:29:25 CST