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

moe wrote:
> 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 :(
>
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1090544094.313161_at_yasure>...
>

>>moe wrote:
>>
>>
>>>Debugging in pl/sql is HELL
>>
>>Then take a class and learn how to debug PL/SQL code. It is, quite
>>frankly, easy. And I mean in SQL*Plus. All those fancy tools aren't
>>worth the cost of a magnet to reformat your hard disk.
>>
>>Daniel Morgan

Making it hard on yourself. Why not create do this:

CREATE TABLE app_log (
output VARCHAR2(4000),
outwhen TIMESTAMP DEFAULT SYSTIMESTAMP);

Then output into it whatever and whenever you want?

Daniel Morgan Received on Fri Jul 23 2004 - 02:13:52 CDT