Re: ways to debug stored procedures

From: Rob Calfee <trace_at_primenet.com>
Date: Mon, 13 Dec 1999 10:13:15 -0700
Message-ID: <83399f$p9b$1@nnrp02.primenet.com>

You can try SQL Navigator or TOAD. Both provide ways to walk through your code and set watches, plus a
multitude of other features which can become unbearable to live without. SQL Nav can be tried out for 30 days at www.quest.com and is rather inexpensive. TOAD is also sold by Quest but you can get the freeware version at www.toadsoft.com but you will need to download it every 60 days, not because of hassle, but because they fix bugs or add new stuff to the freeware version every now and again. The commercial version at Quest rocks and has more features than I can describe. Check them out!

Rob Calfee
l_robert_c_at_yahoo.com

john kelly <johnt.kelly_at_worldnet.att.net> wrote in message news:38544dcc.593172_at_netnews.worldnet.att.net...
> 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.
>
> Thanks
> John
Received on Mon Dec 13 1999 - 11:13:15 CST