Re: SQL buffer overflow.

SQL >show maxdata
will show you what the value is, probably 60000.

SQL> show arraysize
will show you what value this is, probably 20.

I'm still trying to work out exactly why this problem occurs - and just what the hell arraysize and maxdata are! :-).

My current understanding is that arraysize is the number of columns that are fetched for any one fetch and maxdata is the maximum amount of data that can be fetched for any one fetch, measured in 'bits'!

I could be totally wrong in this but I've been doing some tests and it seems to point to this conclusion.

I'm willing to bet that even though your customer table doesn't have many rows it has either a large number of fields in each row or contains one or more varchar2(2000) fields in each row.

In practical terms if you have problems like this set the arraysize low and maxdata high. eg. arraysize 3, maxdata 60000.

Hope this helps,
Rowan.

bmolish_at_my-dejanews.com wrote:

> I am using Oracle 7.34 on NT and oracle SQL PLUS 3.3.
> When I try to do a simple SQL query to view a table., I receive the following
> error. I receive the following error
>
> "buffer overflow. Use SET command to reduce
> ARRAYSIZE or increase MAXDATA"
>
> I have used the SET command to try to reduce the arraysize and/or increase the
> maxdata command and it doesn't seem to
> work.
>
> The query I am doing is.
> Select * from customer;
> There currently are only 42 rows in that table.
>
> Any suggestions would be appreciated. Also, who do I check to see what the
> Arraysize and maxdata are set to?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
Remove the anti-spamming thingy from my email address to reply to me.

The opinions expressed are my own and do not represent the opinions of my company. Received on Thu May 28 1998 - 01:16:41 CDT