From: "Scott Mattes" Newsgroups: comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server References: <9fjhhe$1r8$1@lacerta.tiscalinet.it> <3B1DC671.E63D884D@exesolutions.com> Subject: Re: PL/SQL and DEBUG, which tool ? Lines: 33 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Wed, 06 Jun 2001 14:03:59 GMT NNTP-Posting-Host: 65.196.171.96 X-Complaints-To: abuse@adelphia.net X-Trace: news2.news.adelphia.net 991836239 65.196.171.96 (Wed, 06 Jun 2001 10:03:59 EDT) NNTP-Posting-Date: Wed, 06 Jun 2001 10:03:59 EDT 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" wrote in message news:3B1DC671.E63D884D@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 >