Re: Buffer overflow, Use SET command to reduce ARRAYSIZE or

Do you run any queries before you get to the SQL prompt, ie with the login.sql file?
That error comes up when querying against field(s) with a LOT of characters (or data) in them. For example, usually if you try querying the when_clause and description field together (or doing a select * ) from the dba(user/all)_triggers table, you'll get this error.

Check your login.sql or glogin.sql on the computer that you on when you connect to sqlplus.

HTH
Lyall Barbour

At 06:57 AM 8/18/00 -0800, you wrote:
>I just installed Oracle Enterprise Edition 8.0.5 on a Solaris system and
>when I try to connect to the instance, I've the following message
> Buffer overflow, Use SET command to reduce ARRAYSIZE or increase MAXDATA
>Is there something that I forgot to do ?
>
>Please help !!!
>----------------------------------------------------------------------------
>--------
>@biy @lemu
>abiy.alemu_at_criltelecom.com <mailto:abiy.alemu_at_criltelecom.com>
>Cril Telecom Software
>France
>
>--
>Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Fri Aug 18 2000 - 12:32:59 CDT