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
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi,

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??

Regards
Gaurav
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
BlackSwan
Messages: 25049
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: 64145
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.

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


Current Time: Fri Dec 09 11:42:43 CST 2016

Total time taken to generate the page: 0.11577 seconds