Re: What is debugging tool for PL/SQL?

From: Jim Miles <jmiles_at_technosolutions.com>
Date: 1996/12/06
Message-ID: <588qfu$7fq_at_news.pacifier.com>#1/1

You can download SQL Navigator from http://www.technosolutions.com

It provides an integrated development environment for Stored procedures with advanced features like
* Precise highlighting of compilation errors (No more counting lines   and column numbers)
* "Drag and Drop coding"
  (Drag and Drop PL/SQL syntax, Column names, Db object names,    SQL Functions..In fact just about anything.)

* Fully customizable COLOR syntax hilighting and printing.
* Programmable keyboard (PL/SQL syntax is preprogrammed into the keyboard)
* Support for "Set serveroutput On" for debugging 

  (Many shortcuts for debugging)
* Block Indent/UnIndent, Block Comment/UnComment, Parenthesis balancing etc. * Check In/Check Out

Other features include
* Color coded Graphical Explain PLan
* Ad hoc query module with spreadsheet data output,   (Data export also supported)

* Data can be edited on the fly! (Create/Edit test data!)
* A handy SQL Catalog to save frequently used SQL statements. 
* SQL script processor
* A multitude of Visual object editors for database objects 

  like Table,Trigger, Index etc.

Numerous screen shots and feature list of SQL Navigator is available at TechnoSolutions Web site http://www.technosolutions.com. You can also download a trial copy.

Current version of SQL Navigator is 16bit and is certified to work on Win95/NT, the 32bit version is scheduled for release in Jan'97.

For more information call 360-260-0710

Regards
Jim

>When having hundreds of lines in a stored procedure
>it would be much better to be able to know at which line
>there are errors insted of only seeing message
>"Warning: PACKAGE BODY xyx created with compilation errors"
>
>Does anybody knows such a tool or procedure?
>
>Thanks a lot.
>
>Bobby
Received on Fri Dec 06 1996 - 00:00:00 CET