Re: pl/sql debuggers?

From: Bryan Dollery <bryan_at_bryan.prestel.co.uk>
Date: 1997/07/12
Message-ID: <33C7FB59.34D51B79@bryan.prestel.co.uk>#1/1

This is a multi-part message in MIME format.

--------------A975E1859FC9FABFC6A771D9
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I've been looking for such a tool for a while now. There is only one true debugger that I can find, from a compnay called Platinum, th eproduct is called something like SQL-Station, and costs a few thousand dollars.

I have developed a small server side pricing engine for my employer's international catalogue, and this is over fifteen thousand lines long, and covers abount twelve packages. I have managed it mostly using VI and SQL+ under AIX-Unix. They would't buy me the debugger.

I have found it usefull to place lines like

DBMS_OUTPUT.PUT_LINE('ROUTINE:: 1') ; inbetweeen every two lines of code in my routines. This means that I can get at least some output representing the flow of the code. There is all the call stack which can be output, although I don't bother with that too often, so I can't recall the exact invocation string without my reference texts, which are in work.

Hope this helps.

Bryan

Bryan Dollery BSc.(Hons).
MD - ByteSmart Systems Ltd.

infowerk wrote:
>
> 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.

>

--------------A975E1859FC9FABFC6A771D9
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Bryan Dollery
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Bryan Dollery
n:              Dollery;Bryan
org:            ByteSmart Systems Ltd.
adr:            ;;;;;;England
email;internet: bryan_at_bryan.prestel.co.uk
note:           Consultant Software Engineer

=0A=
B.Sc. (Hons). Software Engineering
=0A=
MD - ByteSmart Systems Ltd.
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
end: vcard

--------------A975E1859FC9FABFC6A771D9-- Received on Sat Jul 12 1997 - 00:00:00 CDT