Re: Newbie: Oracle logging facility

If you have Oracle 8i (and of course you don't specify which version you are using) you can use autonomous transactions for this purpose.

Hth,

Sybrand Bakker, Oracle DBA

"Jeffrey Mark Braun" <jeffb_at_halcyon.com> wrote in message news:8i6gb9$hoj$1_at_halcyon.com...
> I want to log exceptions which occur in my stored procedures, and I
> was using a table I created to save this information, but in some cases I
> want to rollback all the modications in my transation, but of course this
> means any inserts I've made to the logging table will be rolled back as
> well, and thus I lose my logging information.
>
> I understand Oracle has some sort of logging facility which exists outside
> the current transaction, to deal with this situation. Can someone tell me
 what
> this facilties is (perhaps point me to a technet.oracle.com page for more
> info). Also, if you have an example of this in use that would great.
>
> Thanks.
>
> Jeff Braun
>
> p.s.
> Any messages sent directly to me I will repost for others to learn from.
Received on Wed Jun 14 2000 - 00:00:00 CDT