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: PL/SQL: dbms_output problem

Re: PL/SQL: dbms_output problem

From: Eric Givler <egivler_at_nttc.edu>
Date: 2000/06/19
Message-ID: <rfs35.6$oW3.1460@news.flash.net>#1/1

Try: UTL_FILE then instead, and write to an OS file. You could also use DBMS_PIPE, send each line to another process that logs it to a file.

"QBA" <jaczpl_at_ifs.com.pl> wrote in message news:8ilb11$211h$1_at_news.ipartners.pl...
> 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>
>
>
>
Received on Mon Jun 19 2000 - 00:00:00 CDT

Original text of this message

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