Re: SQL buffer overflow.

bmolish_at_my-dejanews.com wrote (in
<6k1g93$9s0$1_at_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
Hello,
 Try:
 set arraysize 1

There are limits to the maximum data size that can be retrieved.

Show all

will show all the current values for you SQL*Plus session.

graham Received on Thu May 21 1998 - 10:26:58 CDT