Re: serveroutput in PL/SQL scripts

did you set spool on ?

Adam wrote:

> Hey.
>
> I have a PL/SQL script which is about 850 lines long. Along the way I have
> some dbms_ouput.put_line statements to show progress and so on.
>
> But it seems to me that when I execute the script from SQL*Plus the output
> doesn't show until the entire script has executed, and this is a problem
> because somewhere along the line it hangs the DB for some reason, and I
> don't know where. I realise I could comment out parts of the program, but
> that will take 100 years to trace the error. Instead, I would like to see
> the output lines when they are called, instead of when the script finishes,
> so that I can see where it fails or infinite loops or whatever.
>
> Anybody know of a SQL*Plus setting or PL/SQL command that forces the output
> on screen as the .put_line commands are reached?
>
> Thanks,
> Adam
Received on Thu Aug 23 2001 - 13:49:45 CEST