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 -> Trigger problem @ Execution

Trigger problem @ Execution

From: David Jeyathilak <david_at_ionideainteractive.com>
Date: 18 Nov 2001 21:06:54 -0800
Message-ID: <3e9566e2.0111182106.6cefb39e@posting.google.com>


Hi,
When I compile a trigger, it shows no errors. But at the time of execution it throws up the following error message. What could be wrong?

ORA-04091: table dbname.table1 is mutating, trigger/function may not see it
ORA-04088: error during execution of trigger 'dbname.trgA'

regards,
David. Received on Sun Nov 18 2001 - 23:06:54 CST

Original text of this message

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