Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL buffer overflow.

SQL buffer overflow.

From: <bmolish_at_my-dejanews.com>
Date: Thu, 21 May 1998 15:12:35 GMT
Message-ID: <6k1g93$9s0$1@nnrp1.dejanews.com>


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 Received on Thu May 21 1998 - 10:12:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US