Re: serveroutput in PL/SQL scripts

The default behaviour of dbms_output ans SQL*Plus is to display output right after the script has ended.
You may want to use utl_file to output stuff to a file instead.

You cannot open a spooled file externally until you issue a SPOOL OFF, the OS will complain that the file is locked.

Sowwy ;-(

"Adam" <ask_at_me.spam> wrote in message news:<LE4h7.64$Nz1.1724_at_news.get2net.dk>...
> 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 Fri Aug 24 2001 - 10:28:18 CEST