Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Need help with error: buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA.

214 views
Skip to first unread message

Chris Schoenfeld

unread,
Aug 4, 1998, 3:00:00 AM8/4/98
to
I have a table:

Name Null? Type
------------------------------- -------- ----
RESULT_ID NOT NULL NUMBER(38)
TIMESTAMP NUMBER(38)
SURVEY_ID NUMBER(38)
QUESTION_1 VARCHAR2(1024)
QUESTION_1_TEXT VARCHAR2(1024)
QUESTION_2 VARCHAR2(1024)
QUESTION_2_TEXT VARCHAR2(1024)
QUESTION_3 VARCHAR2(1024)
QUESTION_3_TEXT VARCHAR2(1024)
QUESTION_4 VARCHAR2(1024)
QUESTION_4_TEXT VARCHAR2(1024)
QUESTION_5 VARCHAR2(1024)
QUESTION_5_TEXT VARCHAR2(1024)
QUESTION_6 VARCHAR2(1024)
QUESTION_6_TEXT VARCHAR2(1024)
QUESTION_7 VARCHAR2(1024)
QUESTION_7_TEXT VARCHAR2(1024)
QUESTION_8 VARCHAR2(1024)
QUESTION_8_TEXT VARCHAR2(1024)
QUESTION_9 VARCHAR2(1024)
QUESTION_9_TEXT VARCHAR2(1024)
QUESTION_10 VARCHAR2(1024)
QUESTION_10_TEXT VARCHAR2(1024)
QUESTION_11 VARCHAR2(1024)
QUESTION_11_TEXT VARCHAR2(1024)
QUESTION_12 VARCHAR2(1024)
QUESTION_12_TEXT VARCHAR2(1024)
QUESTION_13 VARCHAR2(1024)
QUESTION_13_TEXT VARCHAR2(1024)
QUESTION_14 VARCHAR2(1024)
QUESTION_14_TEXT VARCHAR2(1024)
QUESTION_15 VARCHAR2(1024)
QUESTION_15_TEXT VARCHAR2(1024)

When I do a:
SQL> select * from RESULTS; #BTW, I have not inserted anything yet!!!

I get this response from SQLPLUS:
buffer overflow. Use SET command to reduce ARRAYSIZE or increase
MAXDATA.

I cannot increase MAXDATA beyond the default of 60000, and reducing
ARRAYSIZE didn't help.

Any help would be appreciated.

Thanks
Chris


Martijn van Gorp

unread,
Aug 5, 1998, 3:00:00 AM8/5/98
to
Well, try :

set arraysize 1

will probably help you,

greetings,

Martijn van Gorp

Steve Cosner

unread,
Aug 5, 1998, 3:00:00 AM8/5/98
to
That is a pretty ugly table. I understand that any time you use a
Varchar2 item, pl/sql allocates space for the full length, even if
your data never gets that large. I would try to shorten the maximum
lengths of your columns.

Steve Cosner


In article <35C7C82F...@ixlabs.com>,


Chris Schoenfeld <ch...@ixlabs.com> wrote:
>I have a table:
>
>Name Null? Type
> ------------------------------- -------- ----
> RESULT_ID NOT NULL NUMBER(38)
> TIMESTAMP NUMBER(38)
> SURVEY_ID NUMBER(38)
> QUESTION_1 VARCHAR2(1024)
> QUESTION_1_TEXT VARCHAR2(1024)

<snipped Q.2 thru Q.14>

Girish Jashnani

unread,
Aug 6, 1998, 3:00:00 AM8/6/98
to
use
set serveroutput on size 1000000


Girish Jashnani

Alan D. Mills

unread,
Aug 6, 1998, 3:00:00 AM8/6/98
to

--
Alan D. Mills


Steve Cosner wrote in message <6q8qav$so...@hendrix.csufresno.edu>...


>That is a pretty ugly table. I understand that any time you use a
>Varchar2 item, pl/sql allocates space for the full length, even if
>your data never gets that large. I would try to shorten the maximum
>lengths of your columns.

or, could you not restructure the desing into a master/details relationship.
You wouldn't then be limited to 15 questions either. You'd have to report
differently though...

>
>Steve Cosner

Jerry Gitomer

unread,
Aug 6, 1998, 3:00:00 AM8/6/98
to
Steve Cosner wrote:
>
> That is a pretty ugly table. I understand that any time you use a
> Varchar2 item, pl/sql allocates space for the full length, even if
> your data never gets that large. I would try to shorten the maximum
> lengths of your columns.
>
> Steve Cosner
>
> In article <35C7C82F...@ixlabs.com>,
> Chris Schoenfeld <ch...@ixlabs.com> wrote:
> >I have a table:
> >
> >Name Null? Type
> > ------------------------------- -------- ----
> > RESULT_ID NOT NULL NUMBER(38)
> > TIMESTAMP NUMBER(38)
> > SURVEY_ID NUMBER(38)
> > QUESTION_1 VARCHAR2(1024)
> > QUESTION_1_TEXT VARCHAR2(1024)
> <snipped Q.2 thru Q.14>
> > QUESTION_15 VARCHAR2(1024)
> > QUESTION_15_TEXT VARCHAR2(1024)
> >
> >When I do a:
> >SQL> select * from RESULTS; #BTW, I have not inserted anything yet!!!
> >
> >I get this response from SQLPLUS:
> >buffer overflow. Use SET command to reduce ARRAYSIZE or increase
> >MAXDATA.
> >
> >I cannot increase MAXDATA beyond the default of 60000, and reducing
> >ARRAYSIZE didn't help.
> >
> >Any help would be appreciated.
> >
> >Thanks
> >Chris

--
Jerry Gitomer ICT Group
jgit...@ictgroup.com Langhorne PA
jgit...@yahoo.com Opinions are mine not those of ICT Group

Jerry Gitomer

unread,
Aug 6, 1998, 3:00:00 AM8/6/98
to
Hi Steve,

Are you sure that PL/SQL reserves the length of the data item? I ask
because in the tables VARCHAR2 requires the ACTUAL length of the data +
2 bytes.

regards

Jerry

bp...@my-dejanews.com

unread,
Aug 7, 1998, 3:00:00 AM8/7/98
to
Hi Martijn,

In looking thru this thread, I see that your solution is the only one that
seems to work. I tested this and found that only arraysize=1 will work. Now,
could you explain WHY?

Much obliged

Brian

In article <35C867DB...@worldonline.nl>,
Martijn van Gorp <mvan...@worldonline.nl> wrote:
>
> --------------9A6A76ECF3C6B45BCEFFE1C7
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit

> --------------9A6A76ECF3C6B45BCEFFE1C7
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <HTML>
> Well, try :
>
> <P><B><FONT SIZE=+1>set arraysize 1</FONT></B>
>
> <P>will probably help you,
>
> <P>greetings,
>
> <P>Martijn van Gorp
> <BR>&nbsp;
> <BR>&nbsp;
>
> <P>Chris Schoenfeld wrote:
> <BLOCKQUOTE TYPE=CITE>I have a table:
>
>
<P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> Null?&nbsp;&nbsp;&nbsp; Type
> <BR>&nbsp;------------------------------- -------- ----
>
<BR>&nbsp;RESULT_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> NOT NULL NUMBER(38)
>
<BR>&nbsp;TIMESTAMP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> NUMBER(38)
>
<BR>&nbsp;SURVEY_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> NUMBER(38)
>
<BR>&nbsp;QUESTION_1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_1_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_2_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_3_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_4_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_5_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_6_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_7_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_8_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_9_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_10_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_11_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_12_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_13_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_14_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
<BR>&nbsp;QUESTION_15_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> VARCHAR2(1024)
>
> <P>When I do a:
> <BR>SQL> select * from RESULTS; #BTW, I have not inserted anything yet!!!
>
> <P>I get this response from SQLPLUS:
> <BR>buffer overflow. Use SET command to reduce ARRAYSIZE or increase
> <BR>MAXDATA.
>
> <P>I cannot increase MAXDATA beyond the default of 60000, and reducing
> <BR>ARRAYSIZE didn't help.
>
> <P>Any help would be appreciated.
>
> <P>Thanks
> <BR>Chris</BLOCKQUOTE>
> &nbsp;</HTML>
>
> --------------9A6A76ECF3C6B45BCEFFE1C7--
>
>


-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

bp...@my-dejanews.com

unread,
Aug 7, 1998, 3:00:00 AM8/7/98
to
Hi Martijn,

I've been following this thread and it seems that your answer is the only one
that works. However, it only works for arraysize=1. Could you explain WHY?
Much obliged.

Brian

In article <35C867DB...@worldonline.nl>,
Martijn van Gorp <mvan...@worldonline.nl> wrote:
>
> --------------9A6A76ECF3C6B45BCEFFE1C7
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>

-----== Posted via Deja News, The Leader in Internet Discussion ==-----

na...@hotmail.com

unread,
Aug 8, 1998, 3:00:00 AM8/8/98
to
I'm no Martin, but I think I can attempt this...

The maximum amount of data that you could retrieve from one row is:
38*3 for 1st 3 columns and 1024*30 for next 30 columns, which equals
30834.

Well, with an array size of 60000, you can only fit one 30834 into it.

I guess SQL*Plus doesnt care what data you HAVE, it must only care about
the maximum potential buffer size.

Hope this helps...

-Frank

In article <6qffeq$dsr$1...@nnrp1.dejanews.com>,

sp;&nbsp;
> > Null?&nbsp;&nbsp;&nbsp; Type
> > <BR>&nbsp;------------------------------- -------- ----
> >
>
<BR>&nbsp;RESULT_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > NOT NULL NUMBER(38)
> >
>
<BR>&nbsp;TIMESTAMP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > NUMBER(38)
> >
>
<BR>&nbsp;SURVEY_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > NUMBER(38)
> >
>
<BR>&nbsp;QUESTION_1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_1_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_2_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_3_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_4_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_5_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_6_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_7_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_8_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> > VARCHAR2(1024)
> >
>
<BR>&nbsp;QUESTION_9_TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

bp...@my-dejanews.com

unread,
Aug 10, 1998, 3:00:00 AM8/10/98
to
Frank,

I think you're on the right track with that, but some small parts of the
puzzle are still missing. I can set the arraysize to 1 and bring the maxdata
down as far as 36254 and it still works. However, if I try 36253 I get the
error again. There must be some overhead involved (36254-30834), but I don't
know how you would calculate it. Thanks for your help --

Brian

In article <6qgeu5$eh4$1...@nnrp1.dejanews.com>,

0 new messages