Re: Mutating table work-around?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 16 Mar 2000 19:42:02 +0800
Message-ID: <38D0C88A.661B@yahoo.com>

Jim wrote:
>
> We've got a Trigger on a table which recalculates one field based on a
> change to another (and then updates the other value in the same row), so we
> get a :ORA-04091: table WPB.PLAN is mutating, trigger/function may not see
> it - error (obvious now). We're on Oracle 7.3.
> Anyone know how to get around this one? I think I saw a solution a few
> months ago somewhere but our users want the fix to go in this weekend!
> Thanks
> Jim Gillies

Have a look at:

http://govt.oracle.com/~tkyte/Mutate/index.html --

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Thu Mar 16 2000 - 05:42:02 CST