Auditing Changes in a Table.

I am trying to create a trigger that adds a record to a audit table when ever a change is made in a table.

c1 is a cursor of column names

open c1
fetch c1 into colname;

if :new.colname <> :old.colname then /* This is the problem */

    ???
end if;

Is there any way to de-reference these variables (colname) so that I can create a generic trigger.

Thanks for any help.
Jason Greiner Received on Mon Jul 07 1997 - 00:00:00 CDT