Re: It makes me go nuts!!!!!!!!

dbms_system.ksdwrt(1,'Debug comment')

1 to write to the standard trace file
2 to write to the alert log
3 to write to both at once.

You will have to have the privilege execute dbms_system to do this though.

-- 
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 July 20th




"moe" <moe_fiddle_at_thegolfcourse.com> wrote in message
news:910a3d79.0407222159.3c0602d6_at_posting.google.com...


> Do you use 'self made' debug table just to trace things.

> DBMS_OUTPUT.PUT_LINE does not help one bit if you want to trace what

> DBMS jobs are doing.

>

> If I wanted to output a trace to a file I first have to set up oracle

> so that it has a debug directory then create the file and output to

> it. All I want is a simple trace and even the Oracle books cannot help

> me with that :( and all that setting up stuff is just ugly.

>

> tora is not bad. Maybe there are other packages out there for linux,

> but what I am doing (i dont think) is not all that large so that it

> would be worth paying out hundereds of dollars.

>

> Maybe I was spoilt on Smalltalk - I dont know. Or maybe - as someone

> suggested - there is a better way. If so I have not found it :(

>