Re: SQL Debuggers/Toolkits

nwhitehead_at_rocketmail.com wrote:
> >I have been searching for PL/SQL debuggers and toolkits. So far, I have
> >found:
> >
> > SQL Navigator (www.technosolutions.com)
> > Platinum SQL Workstation (www.platinum.com)
> > XPediter/SQL (www.compuware.com)
> >
> >(Note: All of these have a trial/download program; see company web
> >sites)
> >
> >Does anyone have any experience with any of these products or could
> >recommend a product that covers similar functionality?
> >
> >Thank you
> >
> >Bob LoCicero
> >University of Vermont
> >robert.locicero_at_uvm.edu

Try also the Tool HORA of KeepTool (see www.keeptool.swn.de for a free trial version of HORA).
The page procedures and packages of HORA shows the source text of every stored procedure or package stored in the database for the user. In the left combobox you can select between the display of procedures, bodies, packages or package bodies. The list below contains the name of all objects of the selected type. After clicking on any object's name the source code will be displayed in the right window. The following features are supported:

 The source text can be edited directly in the window.

 By clicking on the button you can recompile the PL/SQL object.

 Errors from the last compilation are displayed. The right window is split into two parts: in the upper part you see the error text, in the lower part the corresponding source text is highlighted.

 The navigator allows positioning between the displayed errors. The corresponding source text error positions will be selected.

The current source text line and row numbers is displayed in the panel below. You can find a given line number, i.e. a runtime error line number, by clicking on the button.

Jan Dieckmann (KeepTool GbR)
keeptool_at_swn.de Received on Tue Oct 21 1997 - 00:00:00 CEST