Re: PL-SQL

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 21 Feb 2007 10:14:47 GMT
Message-ID: <45dc1b17.2014828@news.hetnet.nl>

On 19 Feb 2007 02:55:27 -0800, "Suresh" <avsuresh.chowdary_at_gmail.com> wrote:

>Hi All,
> I am using PL-SQL, I have Probelm with spooling more than max
>buffer can hold. I set serveroutput as
>
> set serveroutput on size 100000
>
>and then I am running my procedures
>
>After 35,000 records buffer problem is coming. I am facing the error
>
> ORA - 20000: ORU - 10027: Buffer overflow, limit of........
>
>Is there any solution to my problem???
>
>Or can we directly import results of queries directly into a text file
>from procedure itself???
>
>I shall be very thankful to you, if you mail me with solution at
>avsuresh.chowdary_at_gmail.com
>
>Thanks in Advance,
>A.V.Suresh
>

If you really set it to 100000 (one hundred thousand), then you could add an extra naught, because 1000000 (one million) is the maximum.

Jaap. Received on Wed Feb 21 2007 - 04:14:47 CST