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

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'


Re: Trigger problem @ Execution [message #36345 is a reply to message #36341] Mon, 19 November 2001 05:05 Go to previous message
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: Fri Jun 25 05:41:59 CDT 2021