Re: serveroutput in PL/SQL scripts

[Quoted] No, because I don't need to output anything to a file. Just the screen, like [Quoted] I wrote. And, YES Serveroutput is ON.

[Quoted] "Markus Stuhlpfarrer" <mstuhlpfarrer_at_hollomey.com> wrote in message news:3B84EDBA.1F2E14C1_at_hollomey.com...
> 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 - 14:09:51 CEST