Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Mutating table work-around?
Look at DBMS_PIPE in the Oracle Docs.
Jim <lermontovb_at_hotmail.com> wrote in message
news:8ar7pj$h2r$1_at_lure.pipex.net...
> 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
>
>
>
Received on Sat Mar 18 2000 - 02:03:02 CST