You can use dbms_output.get_line to remove data from dbms_output. What you
do with it is another problem.
"Grigoriy Godkin" <ggodkin_at_wi.rr.com> wrote in message
news:4zCg7.139641$Jg.17662875_at_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 Wed Aug 22 2001 - 03:29:15 CDT
