Re: Auditing Changes in a Table.

Why don't you try database Trigger ?

Jason Greiner wrote:

> 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 Tue Jul 08 1997 - 00:00:00 CDT