serveroutput in PL/SQL scripts

[Quoted] [Quoted] I have a PL/SQL script which is about 850 lines long. Along the way I have [Quoted] [Quoted] some dbms_ouput.put_line statements to show progress and so on.

[Quoted] But it seems to me that when I execute the script from SQL*Plus the output [Quoted] [Quoted] doesn't show until the entire script has executed, and this is a problem [Quoted] [Quoted] because somewhere along the line it hangs the DB for some reason, and I [Quoted] don't know where. I realise I could comment out parts of the program, but [Quoted] that will take 100 years to trace the error. Instead, I would like to see [Quoted] the output lines when they are called, instead of when the script finishes, [Quoted] so that I can see where it fails or infinite loops or whatever.

[Quoted] [Quoted] Anybody know of a SQL*Plus setting or PL/SQL command that forces the output [Quoted] on screen as the .put_line commands are reached?

Thanks,
Adam Received on Thu Aug 23 2001 - 12:11:00 CEST