Re: PL/SQL and DEBUG, which tool ?

If you are using Designer you could do what I have done, write a small procedure that uses text_io to write lines to a file. I open and close the file for each write, so that I can view the progress while the code is running (this gets you around two major problems with dbms_output; 1) the max limit of 1,000,000 bytes that can be written, and 2) not seeing any of the msgs until after the run is completely over).

I sure am spoiled by languages with real debugging features, like Delphi.

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B1DC671.E63D884D_at_exesolutions.com...
> stefano mura wrote:
>
> > Hallo,
> >
> > I must debug a very long procedure written in PL/SQL.
> > Which tool do you suggest me to debug that procedure ?
> >
> > Thanks very much
> >
> > Stefano, Italy
>
> You can get SQL Navigator, or TOAD, or probably a few dozen other
> products. But I find that most of the time I get more than adequate help
> for my debugging by just typing SHOW ERR in SQL*Plus. And for runtime
> errors using DBMS_OUTPUT or an insert into a debug table of my own
> creation.
>
> Daniel A. Morgan
>
Received on Wed Jun 06 2001 - 09:03:59 CDT