Re: commit trigger

From: Bagpuss <remvethis.richard.halford_at_removethis.uk.thalesgroup.com>
Date: Wed, 17 Oct 2001 12:36:44 GMT
Message-ID: <3bcd7aa1.1656707008@news>

On 17 Oct 2001 01:27:20 -0700, p_byrne76_at_hotmail.com (Pascal Byrne) wrote:

>I need to to create a trigger in Oracle 8, that executes when a
>transaction commits.
>
>The trigger will analyze data on logged changes made to specified
>tables during the transaction and remove redundant data. So if a row
>is updated, then deleted, only a record of the deletion is retained.
>
>I know there is no 'on commit' trigger in Oracle, so is there any
>other way of doing it?
>

If you know the tables you wish to analyse then set up a trigger to active after insert,delete or update or each of the tables.

If you are still at the design stage of the app or can mod the code, set up an extra dummy table, say called commit_check (similar to dual) and at the end of transactions write to that & your trigger could monitor that. Of course this is no good if someone does ad hoc stuff or you can't mod _all_ the update transactions that you wish to monitor. Received on Wed Oct 17 2001 - 07:36:44 CDT