Re: SQL+ buffer overflow on select * (minus the confusing message to steve)

From: Michael Tharp <mtharp_at_minn.net>
Date: 1995/10/12
Message-ID: <307DC600.671E_at_minn.net>#1/1

Hagen Finley wrote:
>
> I have encountered another buffer problem using SQL+ (WIN95
 beta)and
> possibly the seasoned DBA's who peruse this list will have
 time to consider
> it. Having integrated concatenation into my insert syntax,the
 inserts are
> working fine now, however, when I do a SELECT * FROM turning;
 I get a
> "buffer overflow" error which goes on to suggest I use SET to
 reduce the
> ARRAYSIZE or to increase the MAXDATA size. Apparently, the
 output to the
> screen associated with my table is larger than the buffer
 provided by SQL. I
> attempted to increase the MAXDATA to 5000 and then 10000, but
 those
> seemingly large numbers had no impact on my ablitity to
 display my longish
> VARCHAR2(750) text columns. I tried to find information on
 ARRAYSIZE and
> MAXDATA in the help files included with the WIN95 beta SQL+
 release, but
> either the information is not there or the marginally
 functional help module
> is too hobbled to carry me to the proper help topic.
>
> Incidentally, I can display the line number & the
 English text
> columns or the line number & the German text, but not both.
>
> SQL> SELECT * FROM turning;
> buffer overflow. Use SET command to reduce ARRAYSIZE or
 increase MAXDATA.
>
> SQL> SELECT line,etext FROM turning
> 2 WHERE line > 30;
>
> LINE
> ---------
> ETEXT
>

---

---

> ------------------------
> 31
> But man is used here in his essence that corresponds to that
 surmounting.
>
> 32
> In keeping with this, mans essence must first open itself to
 the essence of
> technology. This opening
> is, in terms of that coming-to-pass which discloses,
 something quite
> different from the event of ma
> ns affirming technology and its means and promoting them.
>
> SQL> SELECT line,gtext FROM turning
> 2 WHERE line >30;
>
> LINE
> ---------
> GTEXT
>

---

---

> ------------------------
> 31
> Aber der Mensch wird hier in seinem dieser Verwindung
 entsprechenden Wesen
> gebraucht.
>
> 32
> Damit aber das Menschenwesen achtsam werde auf das Wesen der
 Technik, damit
> zwischen Technik und Men
> sch hinsichtlich ihres Wesens sich ein Wesensverhältnis
 stifte, muß der
> neuzeithche Mensch zuvor all
> ererst in die Weite seines Wesensraumes zurückfinden.

ARRAYSIZE is the number of rows held in the array before data goes to the output device (screen, etc.) The default is normally 20 rows.

Try SET ARRAYSIZE 10 and if you get the same message, try 5 and so on. You may even have to do a SET ARRAYSIZE 1.

This works for me with large tables or views.

-- 

Michael Tharp

St. Paul, Minnesota USA
mtharp_at_minn.net

Received on Thu Oct 12 1995 - 00:00:00 CET