Re: SQL*Plus (unusual) problem

Hi there!

Your problem is that the rows returned are very long and overflows your buffer. As already mentioned, you can set arraysize (=number of rows returned at a time) to something low, or you can use the substr-function on the varchar2(2000)-field, selecting for instance only the first 250 characters.

Njål

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.
> Any ideas what else could be wrong?
>
> --
> Boštjan Štupica

--
Njål A. Ekern
n.a.ekern_at_usit.uio.no