Re: PL/SQL error logging

A copy of this was sent to grsnow_at_my-deja.com (if that email address didn't require changing) On Fri, 10 Sep 1999 19:54:47 GMT, you wrote:

>We are designing a PL/SQL error handling
>procedure that will log errors and warnings to an
>error log table. This procedure will be called
>from from a variety of other procedures.
>Unfortunately these procedures need the ability
>to rollback transactions that may occur before
>the error handling procedures.
>
>The question is how can I commit the transactions
>(inserts) performed by the error handling
>procedure, but still be able to rollback those
>transactions outside of the error handler?
>
>I hope it doesn't involve logging errors to a
>flat file instead of a table...
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

In oracle8i, release 8.1 there are autonomous transactions (read about them at the url below)

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Sep 10 1999 - 15:07:24 CDT