Re: Changing arraysize in SQL

Not knowing what operating system you use I cannot tell you the exact location of the global sqlplus configuration file. The filename is glogin.sql and is usually in the sqlplus directory of the oracle software. This file will change the default values for you when you login - but it will also change it for every login --> so be careful.

You can also set up (and is preferable!!) a sqlplus login.sql script that will be executed everytime you log in if your oracle_path is set up. This file can be modified by you and will only affect your sessions. You can set up any and all sqlplus parameters to be used within this file.

Joe Lieto
Redwood Solutions

In article <6kmatj$q25$1_at_nnrp1.dejanews.com>,   bmolish_at_my-dejanews.com wrote:
>
>
> 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
>

-----== 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 - 11:37:55 CDT