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 -> Re: Changing arraysize in SQL

Re: Changing arraysize in SQL

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Fri, 29 May 1998 11:30:38 -0400
Message-ID: <6kmkap$sbv@dfw-ixnews7.ix.netcom.com>


Put the SET ARRAYSIZE in your login.sql file. It is usually located in $ORACLE_HOME\dbs directory

Venkat

>When I run a simple query such as
>select * from customer;
>
>I receive the following error:
>buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA
>
>I will then type in SET ARRAYSIZE 1
>and then I am able to do the query.
>
>How can I change this permanently?
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri May 29 1998 - 10:30:38 CDT

Original text of this message

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