Home » SQL & PL/SQL » SQL & PL/SQL » alternative for mutating error
alternative for mutating error [message #321957] Wed, 21 May 2008 23:16 Go to next message
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member

I am getting mutating error when i am querying the same table on which trigger is based.I want this functionality to be incorporated without error.How can i do this??

Re: alternative for mutating error [message #321958 is a reply to message #321957] Wed, 21 May 2008 23:21 Go to previous messageGo to next message
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
I am sorry to see that both the Search function on this forum & GOOGLE are broken for you.

Please be patient while repairs are undertaken.
Sit back & relax & while a custom answer is being composed for your specific problem.

Re: alternative for mutating error [message #321979 is a reply to message #321957] Thu, 22 May 2008 00:36 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Simply don't do that.
If you need it then your model or code design is wrong.

Previous Topic: Foreign Key Dependency Query
Next Topic: Determining size of database/tables
Goto Forum:

Current Time: Fri Aug 18 11:35:24 CDT 2017

Total time taken to generate the page: 0.24909 seconds