Home » SQL & PL/SQL » SQL & PL/SQL » About Mutating(Trigger)
About Mutating(Trigger) [message #199080] Fri, 20 October 2006 01:07 Go to next message
romi
Messages: 67
Registered: October 2006
Member

Hello All,

Friends,i have knowledge that if there is mutating in trigger then we should remove "for each row" statement from that trigger and make that trigger to "statement level trigger".

But if we want that there should be for each row statement and also don't occur mutating than how can we do it.
Re: About Mutating(Trigger) [message #199083 is a reply to message #199080] Fri, 20 October 2006 01:21 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Link

For more links: push the search button.

MHE
Re: About Mutating(Trigger) [message #199114 is a reply to message #199080] Fri, 20 October 2006 04:49 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member
Thanks to all
Re: About Mutating(Trigger) [message #199118 is a reply to message #199080] Fri, 20 October 2006 05:18 Go to previous message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi,
This article has a simple example of how to work around oracles mutating table issues. It may be some help.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11010

Razz
Previous Topic: Run procedures in parallel (without duplication)
Next Topic: PERFORMANCE
Goto Forum:
  


Current Time: Wed Dec 07 10:26:19 CST 2016

Total time taken to generate the page: 0.11401 seconds