Re: Cascade Delete Help!

From: Tom Niderost <niderost_at_mediaone.net>
Date: Tue, 16 Mar 1999 00:36:52 GMT
Message-ID: <36EDA751.E97EE3E3@mediaone.net>

Thanks. The problem is cleared up.

Thomas Kyte wrote:

> 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 - 18:36:52 CST