On Tue, 27 Jul 1999 21:47:38 -0400, Doug Cowles <dcowles_at_bigfoot.com>
wrote:
>We have some before insert,update,delete triggers that I wanted to put
>a record into a log file for me to read when there is an error, but
>alas, there are no comits allowed in triggers, and when the transaction
>gets rolled back, so does the insert.
>Any ideas?
>
With autonomous transactions in Oracle 8i, this can be done. In prior
releases, you could go the route of using DBMS_PIPE to send the
information to another 'task' that can receive it and then
record/commit the information into your log file.
Received on Tue Jul 27 1999 - 22:08:00 CDT
