Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "buffer overflow" during SELECT from a table!

Re: "buffer overflow" during SELECT from a table!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/24
Message-ID: <953920292.16741.0.pluto.d4ee154e@news.demon.nl>#1/1

set array 1 usually works. If you are running on any microsoft platform you can't increase maxdata.

Hth,

Sybrand Bakker, Oracle DBA

John Smith <a_harrison_ukDEL_THIS_BIT_at_yahoo.co.uk> wrote in message news:kn8ndscklgecg42i9eudgl944hjcvopbud_at_4ax.com...
> Whenever I try to run a select statement from SQLPlus on a certian table I
 get the error
> "buffer overflow. Use SET command to reduce ARRAYSIZE or increase
 MAXDATA."
> Tried changing the suggested setting but no difference - other tables seem
 to be ok!
>
> Any ideas
>
> thanks
>
> Adrian Harrison
Received on Fri Mar 24 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US