Re: dbms_output.put_line not printing

rohit wrote:
> A basic question for you guys... I have dbms_output.put_line
> statements in my pl/sql code, that I expect to print when I execute
> the procedure. I have set the serveroutput on. For some reason the
> output is only displayed once the procedure completes its run, it dont
> print the output as the proc is executing. If I remember correctly,
> using SQLPlus in Oracle 7 on Solaris one could get the print statement
> displayed while the code executed. Is there something I am missing?
> The Oracle version I am using is Oracle 8.1.7, SQL Plus is the the
> standard client that comes with 8.1.7, hardware HPUX.
> Thanks,
> RK

dbms_output.put_line does not do what you think it does. To get an output while somethingis running:

There is no method of doing what you want with just PL/SQL in a single session.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)