Re: How to get output text immediately

If you don't mind sending the output to the database server, you can use utl_file.putf and utl_file.fflush, in a similar way you would use dbms_out.put_line.
You can even pretty up the output by manipulating the output strings... (ex: utl_file.putf(v_filehandle, ' '||v_output_string4||' $(US)'||chr(10)||chr(10));
the above adds leading spaces and a couple of line feed at the end ) Received on Mon Nov 14 2005 - 11:52:08 CST