Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: mutating tables

Re: mutating tables

From: Helen Macduff <Helen.Ward_at_alcatel.com.au>
Date: Wed, 20 Oct 1999 15:35:20 +1000
Message-ID: <380D5498.AC641C7@alcatel.com.au>


I have implimented the solution Sybrand has detailed successfully on a number of sites. Another way is to use a different logic if you are udating, inserting or deleteing from a second table based on the row content of the table the trigger fires on.

Brian Howard wrote:
>
> It seems like everytime I turn around, I'm running into the error that the
> table I am writing a trigger for might be mutating. On some of these I can't
> figure out why. Is there any wisdom out there as to the best way to deal
> with this issue?
Received on Wed Oct 20 1999 - 00:35:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US