help with oracle trigger functionality

Hello all,

attached is a sql script that creates two tables (building, floors) and adds data to the tables. Also included is a trigger and procedure that fires when the floors.gsf value is changed. The trigger is supposed to read the floors.gsf, floors.in_building values, then calculate and update the building.gsf values. I can't seem to get the trigger to update the values for more than one building. Any input or tips to help would be greatly appreciated. Thanks.

John Franklyn
john.franklyn_at_workplacesystems.com