Re: ORA-4091 and mutating tables

From: <tdry_at_brls.com>
Date: Fri, 05 Mar 1999 17:40:00 GMT
Message-ID: <7bp4te$u4$1@nnrp1.dejanews.com>

In article <19990305011736.05213.00003757_at_ng16.aol.com>, unixdba_at_aol.com (UnixDBA) wrote:
> What is the source code of your trigger?
>

It looks like this:

CREATE OR REPLACE TRIGGER child_del
AFTER DELETE
ON child
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
Begin
update parent set detail_lines = detail_lines-1 where key = :old.key; delete parent where key = :old.key and detail_lines = 0; End

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 05 1999 - 11:40:00 CST