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 (buffer overflow)

Re: dbms_output (buffer overflow)

From: Timo Kulju <tkulju_at_cs.joensuu.fi>
Date: 1997/02/19
Message-ID: <5ees90$ih8@cs.joensuu.fi>#1/1

rami_at_lego.ll.utu.fi (Rami Juhela) writes:

>I've checked manuals but I didn't found a solution. I even tried
>'SET FLUSH ON', which according to SQL*Plus user guide disables
>output buffering. It didn't help. Any suggestions???

In SQL*Plus you can use

SET SERVEROUTPUT ON SIZE 1000000 size tells how big the buffer is (between 2000 and 1000000).

--
Timo
Received on Wed Feb 19 1997 - 00:00:00 CST

Original text of this message

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