Re: Newbie: Oracle logging facility

If you don't have Oracle 8i, where you can use autonomous transactions, you can use DBMS_PIPE to send the error messages to an Oracle job (see DBMS_JOB). Marc

Jeffrey Mark Braun wrote in message <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