On 19 feb, 11:55, "Suresh" <avsuresh.chowd..._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.chowd..._at_gmail.com
>
> Thanks in Advance,
> A.V.Suresh
You could:
1) Upgrade (no limit on 10G rel 2)
2) write the outpur to a table, or
3) to a file (UTL_FILE), or
4) use DBMS_PIPE
Received on Mon Feb 19 2007 - 05:27:10 CST
