Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ora error

Re: Ora error

From: Jack <jsilvey_at_texas.net>
Date: 1998/08/23
Message-ID: <35E09DBB.CD1C2A9@texas.net>#1/1

Ah yes, the cryptic mutating table error. Very informative error message, right? What the hell is it mutating into, an index?

Anyway, the mutating table error occurs when you have an update trigger that fires on one table to modify data in another table, and these two tables have a referential integrity relationship.

For instance, let us assume we have two tables, Parent and Child. Child has a foreign key to Parent, and integrity is enforced. When you have a trigger on Parent that tries to modify Child, the mutating error occurs because the constraint exists.

Rewrite your Parent trigger to update a package of variables rather than the Child table. Then, have another trigger update the Child table from the variables in the package. This way, you are not updating Child directly from Parent and you will not recieve this error any longer.

Hope this helps,
Jack Silvey
Oracle DBA
Dell Computer Corporation

VIDEOWAY wrote:

> What means mutating.. ??
> what to do whit an error like that.. ?
> This error append during the execution of a database trigger
> where we insert into gcf_client.
>
> ORA-04091: table GCF.GCF_CLIENT is mutating, trigger/function may not see it
Received on Sun Aug 23 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US