Re: SQL*Plus (unusual) problem

Setting arraysize to 1 will work if there is enough memory/swap space to store 1 row of the data, otherwise the susbtr solution may be needed ( use trial and error to determine the size of the substr )

John Greco

x_at_x.x wrote:

>set arraysize 1
>
>
>>> 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?
>>>
>--
> ------------------------------------
>If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
> http://www.panix.com/~gsa/index.html
Received on Thu Oct 30 1997 - 00:00:00 CET