Re: DEBUGGING TOOL

In article <44531k$h07_at_condor.ic.net> shri_at_mail.ic.net (Srikanth Pattabhi) writes:
>I work for a company which uses both ORACLE 6.0 and 7.0. We use Pro*c and
>PL/SQL extensively for all our programming along with sql*forms.
>Does anyone know of any debugging tools for PL/SQL and Pro*C. If someone
>does know about this, please send me mail and let me know what options I
>have or where I can find all this information.

For PL/SQL development, you should look into Oracle Procedure Builder, now available on Microsoft Windows and Motif.

Procedure Builder provides a GUI, interactive environment for creating and debugging both client-side and server-side program units (including database triggers). Develop and debug your code in the Procedure Builder client, then deposit it in the server with a simple drag and drop action.

Among its features:

• integrated text editor
• interactive compilation errors -- click on an error, and it jumps to that line. No more 'SHOW ERRORS'!!
• set breakpoints
• step through code one line at a time
• view (and change) local variables during program unit execution

For more information, contact your Oracle sales rep, or check out http://www.oracle.com/info/products/tools/procbuilder/intro.html

--Russ

Russ Seligman                 "If there's nothing wrong with me, maybe
Oracle Corporation             there's something wrong with the universe."
rseligma_at_us.oracle.com           --Beverly Crusher, ST:TNG
===============================================================================