Re: PL/SQL Development Tools

Once you have complied stored procedurces, you may need a product to debug them. Our XPEDITER/SQL's debugger for Oracle, lets you clearly understand what is happening with your programs when they run on a server. XPEDITER/SQL allows you to control the logic flow of your application, understand the impact of changes—before they occur.

XPEDITER/SQL lets you execute in Run mode, which automatically stops when the procedure reaches an error or breakpoint, or in Animate or Step mode, which steps through and into procedures on a line-by-line basis. You can step into nested procedures or triggers to debug problem-causing source code. You can also set breakpoints at any executable line of code and for long testing sessions, XPEDITER improves productivity by saving all breakpoints in a debugging session—including all levels of nesting.

XPEDITER/SQL also includes a built-in administrator that provides a unique way to manage multiple development projects with ease, an comprehensive editor that offers powerful capabilities to create and edit stored procedures, and a graphical browser that provides fast access to a hierarchical list of all objects in the Oracle data dictionary. From the browser, XPEDITER can go to any other area of the product. For example, you could launch an editing or debugging session from any package, procedure, function or trigger in the data dictionary.

We now have our BETA release of Xpediter/SQL for Oracle 2.5 on our internet site available for download. XPEDITER/SQL 2.5 for Oracle is now 32 bit, providing faster support for Windows 95 and NT users and the Editor handles unlimited files sizes. Release 2.5 also supports Oracle 8! XPEDITER/SQL introduces two exciting new features: the Monitor and dynamic debugging capabilities. Use the monitor to observe stored procedures throughout system, load and regression testing phases. From the monitor, you have the option of launching into a debugging session and dynamically resolving problems, using real data and parameters passed from the calling application. Also, we have a Lotus screencam demo of the product that you can view. To see the demo and download the beta, go to the following URL:
http://www.compuware.com/products/iad/options/beta/features.htm

XPEDITER/SQL installs on any PC-Windows client (3.15 and above, including all versions of Windows 95 and NT) and provides development and testing of stored procedures running on any Oracle 7.x server that has been configured for connectivity via SQL*Net. XPEDITER provides a graphical interface to Oracle 7.x and above.

Steve Pritchett
Client-Server Tools
Atlanta
770-410-9991

Zernan Martinez wrote:
>
> A development package I have been using for a while is
> SQL Navigator. It has the management capabilities for developing
> PL/SQL.
>
> It's one of the most popular PL/SQL tools around, though I can't think
> of any other one except for Procedure Builder, which you would ignore
> once you use SQL Navigator.
>
> Zern
>
> On Thu, 09 Oct 1997 09:08:06 -0400, "Bryan J. Gentile"
> <bgentile_at_bdsinc.com> wrote:
>
> >Does anyone know of any good PL/SQL developement tools to use to write
> >and compile stored procedures, functions, packages, and package bodies?
> >I am currently using the Oracle Schema Manager to do this, but it is
> >very cumbersome and not a very good interface for writing and compiling
> >stored procedures. If anyone knows of any good tools to use, please let
> >me know. Thanks.
> >
> >--
> >**************************************
> >Bryan J. Gentile
> >Consultant
> >Business Data Services, Inc.
> >Glastonbury, CT 06033
> >Phone: (860) 633-3693 (ext. 3006)
> >Vmail: (ext. 6030)
> >**************************************
> >
> >
Received on Fri Oct 10 1997 - 00:00:00 CDT