DBMS_ output.put_line ERROR

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 - 17:06:53 CDT