Re: help
Date: Fri, 03 Jul 1998 14:53:46 GMT
Message-ID: <359cef7e.1390399_at_192.86.155.100>
A copy of this was sent to "ceiling" <ceiling_at_autumn.ccl.itri.org.tw> (if that email address didn't require changing) On Fri, 3 Jul 1998 16:35:04 +0800, you wrote:
>HI everyone:
> I try to generate a sql statement "select * from overdue",
> the overdue table has a column which length is 4000.
> a sql error happen:
> "buffer overflow. Use SET command to reduce ARRAYSIZE or increase
>MAXDATA."
> how can I solve this problem
> thanks very much.
>
>
>
>
the product of ARRAYSIZE times the maximum width of the row must be less then MAXDATA in sqlplus 3.x and lower (in 8.0 the rules are different, in 8.0 you can set maxdata 0 and arraysize upto 5000 and sqlplus will just do it for you).
You can either up maxdata
SQL> set maxdata 60000
or if maxdata is already 'maxed' out, you can lower arraysize
SQL> set arraysize 1
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jul 03 1998 - 16:53:46 CEST