Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "buffer overflow" during SELECT from a table!
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