Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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
You're mistaken.
Look at dbms_pipe instead, it also overcomes the size barrier.
-- Regards, Frank van BortelReceived on Mon Feb 16 2004 - 15:22:07 CST