Re: SQL*Plus (unusual) problem

Try setting arraysize to minimum (1) and and maxdata to maximum (60000)

John

>
>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.
>Any ideas what else could be wrong?
>
>--
>Boštjan Štupica
>
>
Received on Thu Oct 23 1997 - 00:00:00 CEST