Re: mutating tables?

As others have stated, you cannot modify a row in the table during a insert trigger. The solution is to create a pre-insert/pre-update trigger.
This trigger fires as the database engine tries to insert or update a row. The data in the row is modifyed and then written into the database.

Generally insert triggers are to update other tables at the same time as the current table.

Michael Krolewski

jennifer spain 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-

jennifer spain 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-
Received on Sat Oct 24 1998 - 16:15:41 CDT