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

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL: dbms_output problem

Re: PL/SQL: dbms_output problem

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/06/19
Message-ID: <394DFD84.2011@yahoo.com>#1/1 






QBA wrote:


> 

> How to print a report with large portion of data?

> I'm getting an error:

>  "ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes"

> 

> mail: <jaczpl_at_ifs.com.pl>




Look at UTL_FILE instead of dbms_output.



HTH


-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse


Received on Mon Jun 19 2000 - 00:00:00 CDT












Original text of this message













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