Home » SQL & PL/SQL » SQL & PL/SQL » Help on Triggers
Help on Triggers [message #37002] Wed, 09 January 2002 20:11 Go to next message
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 Go to previous message
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.
Previous Topic: Triger help
Next Topic: how to find terminal and session id from weblogic.
Goto Forum:
  


Current Time: Mon Mar 30 03:13:59 CDT 2020