Home » SQL & PL/SQL » SQL & PL/SQL » solution to mutating trigger (oracle 9i)
solution to mutating trigger [message #430170] Mon, 09 November 2009 06:09 Go to next message
raffee.v
Messages: 12
Registered: May 2008
Junior Member
i am facing the mutating trigger problem. how to solve that problem.

in trigger code depending on the result column value i have to insert one new row in same table.so i am geting trigger error.
how to solve this
Re: solution to mutating trigger [message #430172 is a reply to message #430170] Mon, 09 November 2009 06:15 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Is google broken for you or you cannot access google ?

http://www.oracle-base.com/articles/9i/MutatingTableExceptions.php

Regards

Raj
Re: solution to mutating trigger [message #430180 is a reply to message #430170] Mon, 09 November 2009 06:43 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
It depends. Very often it is caused by either a design issue or by ignorance of the coder.
Maybe if you'd show us some of your code, we could give you some more detailed advice.

[Updated on: Mon, 09 November 2009 06:45]

Report message to a moderator

Previous Topic: Help
Next Topic: sql query
Goto Forum:
  


Current Time: Fri Dec 09 13:49:05 CST 2016

Total time taken to generate the page: 0.15426 seconds