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

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_ output.put_line ERROR

Re: DBMS_ output.put_line ERROR

From: Grigoriy Godkin <ggodkin_at_wi.rr.com>
Date: Tue, 21 Aug 2001 23:56:48 GMT
Message-ID: <4zCg7.139641$Jg.17662875@typhoon.kc.rr.com>


Use UTL_FILE package to create, open, close, and write to file operations. You can not flush the buffer during execution of the procedure.

Greg.

"Mike Aloms" <alomski_at_hotmail.com> wrote in message news:fc5ce0ff.0108211406.30207f9_at_posting.google.com...
> Hi Gurus
>
> Can some please tell me how to get round the error below
>
> ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
> ORA-06512: at line 118.
>
> I was using DBMS_OUTPUT.PUT_LINE to print out some data from the
> database when I ran into the error.
>
> In my script, I did
> dbms_output.disable; dbms_output.enable(1000000); at the beginning of
> the execution section of my pl/sql block.
>
> So do I have to look for another way of writing my data to a file or
> is it possible to flush the buffer?
>
> Many Thanks
> Mike
Received on Tue Aug 21 2001 - 18:56:48 CDT

Original text of this message

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