Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output.put_line not printing

Re: dbms_output.put_line not printing

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 16 Feb 2004 22:22:07 +0100
Message-ID: <c0rc7j$t6p$2@news4.tilbu1.nb.home.nl>


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 Bortel
Received on Mon Feb 16 2004 - 15:22:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US