Re: PL/SQL: dbms_output problem

"Eric Givler" <egivler_at_nttc.edu> wrote:
>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>
>>

Eric is correct in that you probably want to use the utl_file package because the absolute maximum buffer dbms_output can use is 1M and you appear to be attempting to exceed the limit.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Jun 19 2000 - 00:00:00 CDT