Re: Stored Proc tools?

In article <dscott-0402951629130001_at_dscott.is.net> dscott_at_is.net (David Scott) writes:
>I hope to put a stored procedure tool in the hands of 6 SQL
>programmer/analysts, but have not found one yet. Has anyone seen
>ACE-Insight by Legent? I know about SQL Studio (and like it), but we are
>running XWindows and/or Mac clients for this project. Do YOU know of a
>tool that we can use to manage our stored procedure code?

You should look into Oracle Procedure Builder, now available on Microsoft Windows, and available on other platforms (including Motif and Mac) very soon.

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

--Russ

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Russ Seligman
Oracle Corporation
rseligma_at_us.oracle.com
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Received on Mon Feb 06 1995 - 00:36:59 CET