Re: Newbie: Oracle logging facility

In article <8i6gb9$hoj$1_at_halcyon.com>,
  jeffb_at_halcyon.com (Jeffrey Mark Braun) wrote:
> 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.
>

in 8i, you have autonomous transactions, see

http://osi.oracle.com/~tkyte/autonomous/index.html

for a paper on that feature.

prior to 8i, you can use:

o dbms_pipe to write a message to another process (you write this other process) which reads these messages in another session and writes them somewhere.

o utl_file - to write to a "log file" in the OS, which may be sufficient if this is for debugging errors.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.