buffer overflow : why using set ARRAYSIZE

From: Fleury Marcel <marcel.fleury_at_bluewin.ch>
Date: 15 Aug 2002 02:06:16 -0700
Message-ID: <f18358b2.0208150106.3003beb8_at_posting.google.com>


Hello,

Here my table :

SQL> desc test_name;

 Name                            Null?    Type
 ------------------------------- -------- ----
 TEST_NAME                                VARCHAR2(4000)

The table have just 1 record :

SQL> select count(*) from test_name;

 COUNT(*)


        1

SQL> select * from global_name;
buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA. If I set ARRAYSIZE 1, it works.

Question :
As my table has only one row, why have I to set ARRAYSIZE 1 to avoid to get a buffer overflow ?

If I set ARRAYSIZE to 5000 I got the error although I've only one row !!! Received on Thu Aug 15 2002 - 11:06:16 CEST

Original text of this message