Re: SQL*Plus (unusual) problem

Bostjan Stupica wrote:

> Hoj!
>
> I have a table A with definition
> Name Null? Type
> ------------------------------- -------- ----
> OPO_ID NOT NULL NUMBER(8)
> OPOMBA NOT NULL VARCHAR2(2000)
> LOK_ID NOT NULL VARCHAR2(5)
> REP_ID NOT NULL VARCHAR2(200)
>
> Then I make in SQL*Plus simple SELECT
> Exam.: SELECT * FROM TABEL_A WHERE ROWNUM < 2;
> and I (allways) get:
> "buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA."
>
> I've tried to modify those values (ARRAYSIZE and MAXDATA), but I still get
> this message.

did u try setting arraysize = 1

just a thought, joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second, third, etc,
instance, without using oracle's installer, database scripts.
ICQ UIN: 4252226(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).