Re: debug PL/SQL??

Do you also set the max buffer size to max (1,000,000) somewhere?

Being from other programming languages before coming to PL/SQL I think it appalling that PUT_LINE is so awful.

"Jason Burgoyne" <jason.burgoyne_at_bms.com> wrote in message news:3A66FC18.367F000B_at_bms.com...
> Here is what I do
>
> Add DBMS.PUL_LINE comments in the code (with some OAS you need to comment
 out
> the htp calls)
>
> Load the package/procedure/function
>
> (If using a devel package open the DBMS output window)
>
> EXECUTE blah.blah;
>
> This obviously also only works if you do not have a lot of htp calls, and
 have
> well formed exceptions so that the program will always finish executing.
 This
> is much easier done in SQL*plus. Let me know what utils you are using.
>
> JB
>
Received on Thu Jan 18 2001 - 18:44:35 CET