Re: mutating tables?

On Mon, 12 Oct 1998 12:45:39 -0400, jennifer spain <jspain_at_arcus.net> wrote:

>Can't find a word about this one in docs. Seen it?
>
> Oracle Error Code = 4091
>
> ORA-04091: table is mutating,
> trigger/function may not see it ORA-06512: at "", line 2 ORA-04088:
>error during execution of trigger ''
>
>
>Thanks-
>
>>oerr ora 4091

04091, 00000, "table %s.%s is mutating, trigger/function may not see it"
// *Cause: A trigger (or a user defined plsql function that is referenced in
// this statement) attempted to look at (or modify) a table that was
// in the middle of being modified by the statement which fired it.
// *Action: Rewrite the trigger (or function) so it does not read that table.
/oracle [oracle on dcaix02]

HTH,
Paul Kilmer Received on Mon Oct 12 1998 - 12:15:04 CDT