Re: Mutating table work-around?

Usually
create a pl/sql package with an pl/sql table holding the primary keys of the rows affected
before statement : reset the table
after row: buffer the primary keys in the table after statement : perform any additional logic looping through the array.

Hth,

Sybrand Bakker, Oracle DBA

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 Thu Mar 16 2000 - 13:08:41 CST