Re: anyway to intentionally write to the alert log?

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

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th

• Original Message ----- From: <ryan_gaffuri_at_comcast.net> To: <oracle-l_at_freelists.org> Sent: Thursday, October 21, 2004 2:28 PM Subject: anyway to intentionally write to the alert log?

anyway to write whatever i want to the oracle alert log?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 21 2004 - 08:29:44 CDT