Adam wrote:

>Also note!!!!
>
>If you decide to implement your own audit, then you need to be aware
>that rolling back your transaction will also roll back any additions
>that transaction made to your audit log. This may be an issue if you
>need to audit attempts at changing / deleting data etc rather than just
>successful (committed) transactions.
>
>Adam
>
>
>

An option for post-rollback audit is to use an external table.

External tables are not reverted on rollbacks.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br