PL-SQL

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 Received on Mon Feb 19 2007 - 04:55:27 CST