Re: debug PL/SQL??
Date: Thu, 11 Jan 2001 14:14:33 GMT
Message-ID: <ddj76.2460$vW4.15270_at_skycache.prestige.net>
DBMS_OUTPUT seems to be the provided way, BUT it has a couple of serious limitations: 1) max buffer size of 1,000,000 bytes and 2) output is displayed only AFTER execution finishes. Together this means that if you exceed the max buffer you get no output (this really bites when your long running pl/sql finishes 20 minutes later and no output).
TOAD, www.toadsoft.com, allows you to see the dbms_output contents by retreiving it at user defined intervals. There is a free version, but you have to download a new free version about monthly.
I haven't tried yet, but was thinking that maybe what I need to have is a sub-unit that when called opens a text file for append, writes the passed string and then closes the file. That way I can have my editor running with the file open in it and just reload it periodically.
"mark" <markeve_at_mediaone.net> wrote in message
news:pp876.42759$1M.9375307_at_typhoon.ne.mediaone.net...
> Does anyone know of a way to debug pl/sql procedures? I'm currently
working
> with SQL-PLUS and Centura's SQL-TALK.
>
> Thanks.
>
>
Received on Thu Jan 11 2001 - 15:14:33 CET