Re: Tracking changes

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 19 Sep 2003 23:17:54 +0200
Message-ID: <pismmv8qivp3ujravrcb9qpvgd2386vqg9@4ax.com>

On Fri, 19 Sep 2003 14:10:57 -0400, ferraroj <member40432_at_dbforums.com> wrote:

>
>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

The best you can do is design a procedure to generate a customary trigger. The above pseudocode is not going to work.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Sep 19 2003 - 16:17:54 CDT