Within SQLPLUS use the SHOW command to get a list of the values associated
with the SQLPLUS system variables. SHOW ALL will list all variables. SHOW
ARRAYSIZE will list the value for ARRAYSIZE, etc.
bmolish_at_my-dejanews.com wrote in message
<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
Received on Thu May 21 1998 - 10:51:20 CDT
