From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Re: PL/SQL and DEBUG, which tool ?
Date: Tue, 05 Jun 2001 22:58:09 -0700
Organization: EXE
Message-ID: <3B1DC671.E63D884D@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
References: <9fjhhe$1r8$1@lacerta.tiscalinet.it>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yabetcha.drizzle.com!unknown@ava25.drizzle.com
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 19


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