Re: SQL*Plus (unusual) problem

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?
>>

-- 
                     ------------------------------------
[Quoted] 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