Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing arraysize in SQL
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
![]() |
![]() |