Home » SQL & PL/SQL » SQL & PL/SQL » Trigger problem @ Execution
Trigger problem @ Execution [message #36341] Sun, 18 November 2001 19:08 Go to next message
David Jeyathilak
Messages: 9
Registered: October 2001
Junior Member
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.

----------------------------------------------------------------------
Re: Trigger problem @ Execution [message #36345 is a reply to message #36341] Mon, 19 November 2001 05:05 Go to previous message
Susan
Messages: 102
Registered: October 2001
Senior Member
At the time of execution the dbname.table1 is being modified by a DML statement. See the following askTom link for more info.



----------------------------------------------------------------------
Previous Topic: Conversion to Date Format
Next Topic: trigger question
Goto Forum:
  


Current Time: Wed Jul 08 18:27:06 CDT 2020