| Trigger problem @ Execution [message #36341] |
Sun, 18 November 2001 19:08  |
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  |
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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
