Re: write to alert log

Jeffrey Beckstrom wrote:
> In the back of my mind I recall that it is possible to write to the
> alert.log from procedure, but can not recall how. What do I execute to
> do this?
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> --
> http://www.freelists.org/webpage/oracle-l
This came up last week. A cut 'n paste of Jonathan Lewis' response:

<quote>
dbms_system.ksdwrt(1,'test')

     writes to alert log

dbms_system.ksdwrt(2,'test')

     writes to session's trace file

dbms_system.ksdwrt(3,'test')

     writes to both

see also

     dbms_system.ksddt - writes a date-time stamp
     dbms_system.ksdind(N) - indents text using ":' characters
     dbms_system.ksdfls - flushes the write to file

Regards

Jonathan Lewis
</quote>

-- 
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
--
http://www.freelists.org/webpage/oracle-l