DBMS_ output.put_line ERROR
From: Mike Aloms <alomski_at_hotmail.com>
Date: 21 Aug 2001 15:06:53 -0700
Message-ID: <fc5ce0ff.0108211406.30207f9_at_posting.google.com>
[Quoted] Hi Gurus
Date: 21 Aug 2001 15:06:53 -0700
Message-ID: <fc5ce0ff.0108211406.30207f9_at_posting.google.com>
[Quoted] Hi Gurus
[Quoted] [Quoted] Can some please tell me how to get round the error below
[Quoted] 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 - 00:06:53 CEST