Yes, I am using Oracle 9i. Here is the code for the trigger; which compiles. The table which fires the trigger is called TEMP_DT.
DECLARE VAL4 FLOAT(40); BEGIN SELECT SUM(VAL1 + VAL2 + VAL3) INTO VAL4 FROM SCHEMA.TEMP_DT WHERE LOCATION = :OLD.LOCATION GROUP BY LOCATION; UPDATE SCHEMA.TEMP_DT SET OVERALL_SUM = NEW_VAL4 WHERE LOCATION = :OLD.LOCATION; END; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3236 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
