You might want to specify which database you are working with. You would not get that error in MS SQL Server.
-Mike Chabot On Thu, Aug 13, 2009 at 10:49 AM, Nick G<[email protected]> wrote: > > I have a table with four values (val1, val2, val3, overall_val). I have been > trying to create a trigger where after an update is made to either one of the > first 3 values, the sum is added and updated into the overall_val field [ for > each row ]. I can not separate the fields into a different table and I know > this is not the best way to show/store a total field but it is what I have to > work with. Currently when I try a basic update after trigger I get the > ORA-04091 is a mutating trigger error because the :new.val has not been > committed. Does anyone know of a work around to update a row in the same > table that fired the trigger? Thanks in advance. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3234 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
