OraFAQ Forum: SQL & PL/SQL » solution to mutating trigger

Home » SQL & PL/SQL » SQL & PL/SQL » solution to mutating trigger (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

solution to mutating trigger [message #430170]

Mon, 09 November 2009 06:09

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

Report message to a moderator

Re: solution to mutating trigger [message #430172 is a reply to message #430170]

Mon, 09 November 2009 06:15

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

Report message to a moderator

Re: solution to mutating trigger [message #430180 is a reply to message #430170]

Mon, 09 November 2009 06:43

Frank
Messages: 7901
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 14 14:14:54 CDT 2025