Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04091: table XXXX is mutating, trigger/function may not see it
ORA-04091: table XXXX is mutating, trigger/function may not see it [message #202694] Sat, 11 November 2006 00:52 Go to next message
sanjiv_gore2002
Messages: 7
Registered: September 2006
Junior Member
Dear All,

I am facing ORA-04091 error.
I have a table in which some numeric values are getting inserted and i have written after insert trigger to update one numberic value say :new.price. I am doing some calcualtion on :new.price and then i want to update it.
Can any one please regarding same.

Thanks in advance,
Sanjiv
Re: ORA-04091: table XXXX is mutating, trigger/function may not see it [message #202735 is a reply to message #202694] Sat, 11 November 2006 08:38 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Mutating table error has been explained on this Forum and throughout the Internet many, many times. You'll find them using OraFAQ search facility and/or Google (or other search engines).
Previous Topic: retrieve last row inserted
Next Topic: Counting how many times a certain character appears
Goto Forum:
  


Current Time: Sat Dec 10 16:54:43 CST 2016

Total time taken to generate the page: 0.06045 seconds