Home » SQL & PL/SQL » SQL & PL/SQL » Mutating Trigger
Mutating Trigger [message #437598] Tue, 05 January 2010 03:21 Go to next message
deepakhota
Messages: 9
Registered: December 2009
Location: Bangalore
Junior Member
What is mutating Trigger
Re: Mutating Trigger [message #437600 is a reply to message #437598] Tue, 05 January 2010 03:22 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Nothing.

Triggers do not mutate, tables do.

P.S. If you are interested in mutating tables, start here and also visit Ask Tom.

[Updated on: Tue, 05 January 2010 03:24]

Report message to a moderator

Re: Mutating Trigger [message #437603 is a reply to message #437598] Tue, 05 January 2010 03:26 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
or Google

regards,
Delna
Re: Mutating Trigger [message #437604 is a reply to message #437600] Tue, 05 January 2010 03:28 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
A mutating trigger occurs in Oracle when the table that originally fired the triggering event is being accessed in the body of the trigger code, directly or implicitly in a procedure, or in a nested trigger called from the trigger body.

This action is forbidden because the table is in middle of a transaction, and referencing the same table again in the middle of the updating action causes the trigger to mutate.



Explanation

sriram Smile
Previous Topic: sql developer vs toad, indexing
Next Topic: START AND END DATE OF MONTH
Goto Forum:
  


Current Time: Tue Feb 11 18:07:40 CST 2025