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

From: moe <moe_fiddle_at_thegolfcourse.com>
Date: 22 Jul 2004 22:59:10 -0700
Message-ID: <910a3d79.0407222159.3c0602d6@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 :(

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
Received on Fri Jul 23 2004 - 00:59:10 CDT