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