Re: Help debugging in SQLPLUS

From: Russ Seligman <rseligma_at_oracle.com>
Date: 05 Dec 1994 00:11:07 GMT
Message-ID: <RSELIGMA.94Dec4161107_at_seinfeld.oracle.com>


In article <D0597q.7BD_at_cup.hp.com> jbridges_at_cup.hp.com (Jim Bridges) writes:

> I would like to use SQLPLUS (3.1.3.2.1) to debug a stored procedure.

Keep your eye out for Oracle Procedure Builder, due out on Windows in January, and other platforms soon after. It provides a GUI, interactive environment for creating and debugging both client-side (Forms, Graphics, Reports) and server-side program units, including database triggers.

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 Dec 05 1994 - 01:11:07 CET

Original text of this message