Tracking changes

I would like to be able to monitor changes to data within a number of tables. I would prefer to have a routine that was generic and did not rely on the structure of the table. I was thinking of having a "before update trigger" call the routine. Below is an idea of the type of code I'm trying to create

begin

    For all_columns_in_table Loop

        If new.col <> old.col then

            track_change()

        endif

    end for loop

end

--
Posted via http://dbforums.com