| Help on Triggers [message #37002] |
Wed, 09 January 2002 20:11  |
Shibu Samuel
Messages: 5
Registered: January 2002
|
Junior Member |
|
|
I have a table X on which AFTER UPDATE trigger is attached. In the the body of the trigger I am inserting a new record on the same table X. On updation of a record I get following error msg:
ORA-04091: table X is mutating, trigger/function may not
see it
ORA-06512: at "TRGR_X_UPDATE", line 6
ORA-04088: error during execution of trigger
'TRGR_X_UPDATE'
Is there a solution to the problem.
Reply ASAP.
|
|
|
|
| Re: Help on Triggers [message #37003 is a reply to message #37002] |
Wed, 09 January 2002 20:15  |
Somu
Messages: 24
Registered: February 2000
|
Junior Member |
|
|
Hi,
You can't use the same table in the trigger, even you can't use in the select statement, there is no solution for this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
