Re: Debug stored procedures

From: <yitbsal_at_statcan.ca>
Date: Mon, 13 Dec 1999 17:01:09 GMT
Message-ID: <8338oi$dn3$1@nnrp1.deja.com>

In article <38548179.3058708_at_netnews.worldnet.att.net>, johnt.kelly_at_worldnet.att.net wrote:
> Can anyone tell me ways to debug stored procedures. I have several
> stored procedures that call other stored procedures and the only way
I
> know of finding out what is going on is to put dbms_ouput.putline.
> Are there any freeware solutions and any recommendations on
commercial
> solutions.
>

You can debug one of two ways: using scripts that use the dbms_debug and dbms_output packages, and using third-party software.

The scripts are, like any home-grown solution, difficult to use. I favour third-party software, which is, essentially, the scripts done professionally and with an interface.

There are several PL/SQL debuggers available:

SQL Navigator and PL/SQL Debugger for TOAD (Quest Software) SQL Station (Platinum, now CA)
PL/SQL Debugger (AllRoundAutomations)
RapidSQL (Embarcadero Tech.)

And I'm sure there are others. If I were you, I'd download and try them all and pick the best one. Main features to look for are robustness (they crash often), easy creation and storage of parameters, and support for unorthodox data types such as PL/SQL tables and objects.

Salaam Yitbarek

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 11:01:09 CST