From: mconlin@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Mutating - Trigger any way around this ?
Date: Tue, 12 Dec 2000 15:37:04 GMT
Organization: Deja.com - Before you buy.
Lines: 17
Message-ID: <915gmv$h0h$1@nnrp1.deja.com>
NNTP-Posting-Host: 208.63.53.36
X-Article-Creation-Date: Tue Dec 12 15:37:04 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.1 x60.deja.com:80 (Squid/1.1.22) for client 208.63.53.36
X-MyDeja-Info: XMYDJUIDmconlin





I am trying to write a Trigger that deletes other related rows
in a table when certain rows are deleted.

Of course this creates a mutating table / trigger error.

My question is,

Is there anyway around this ?

I can't be the only person to have this problem.


Sent via Deja.com http://www.deja.com/
Before you buy.