Re: pl/sql debuggers?

From: John Meyer <webmaster_at_sfi-software.com>
Date: 1997/07/10
Message-ID: <01bc8d5a$57a5fbc0$0c1bf8ce@unknow.sfi-software.com>#1/1

SQL-Programmer 2.1 does not currently has it's PL/SQL and TRANSACT-SQL Debugger (announced for version 2.5) but it might help you and save you more hours for sleep time.

Just in case, check http://www.sfi-software.com about SQL-Programmer 2.1

Get a live Internet Interactive Tour at: http://www.sfi-software.com/qt/sqlprogrammer20/qtinternet.htm

And full documentation at:
http://www.sfi-software.com/products.htm

If you need help or assistance, call SFI at 819 778-5045, or email info_at_sfi-software.com

Hope this can help,
Sam Q. Lang,
SFI, a Sylvain Faust company

---

Sylvain Faust Inc. (SFI) was founded in 1988 by experienced database programmers intent on improving programmer productivity by developing a suite of tools, utilities and knowledgeware designed by programmers, for programmers. Productivity enhancement software in this market can easily pay for itself in a matter of days just in labor savings, not to mention the competitive advantage gained by organizations able to deploy information systems faster and more reliably. SFI's current products include SQL-Programmer, SQL-Optimizer and SQL-Sombrero.

---

infowerk <infowerk_at_best.com> wrote in article <5q1o62$emb$1_at_nntp2.ba.best.com>...
>
> hello there. I am searching for a good pl/sql debugger, what I mean
> by that is something that I can run my sql through against the database
> (oracle 7.3.2.3) and see exatcly what is being done, so I can review
> what could be causing a problem. I have a really large (hundreds of
 lines)
> sql program, and while it does run it gives me wrong information in the
> database. Because this sql program is so large i can not manage to go
 line
> by line on what its doing while running against the database so I need
> something that can show me (prefer GUI) what its doing while its running.
> I suppose you could call it a fancy explain plan, but i woul really like
 a
> "Debugger" of some sort if it exists. The script isn't failing by no
> means, it is just so large and does somethings to the database that I can
> not pinpoint where wrong information is inserted. I also go the oracl
> 8.0.3 enterprise manager for win95/nt. Can I use that against my older
> rev database to find out this kind of information, and "trace" what the
> sql is doing while its running against the database? Something to
> 'visualize' this monster....
>
> many thanks,
>
>
> ps: I am really looking forward to any information, as this issue has
> caused me a good deal of sleep loss.
>
>
Received on Thu Jul 10 1997 - 00:00:00 CDT