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:3233 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
