Re: Buffer overflow with SQL*Plus

Frank,

Try to REDUCE the arraysize, see if it works.

Wei Liu

In article <7t2m2d$p5k$1_at_bgtnsc03.worldnet.att.net>,   "Frank Siegel" <NorthernSnow_at_worldnet.att.net> wrote:
> Ever since upgrading to Oracle 8.0.5. We often get the error message
> from client SQL*Plus: Release 3.3.3.0.0
>
> "Buffer overflow. Use SET command to reduce ARRAYSIZE or increase
MAXDATA"
>
> when doing
> 1. show errors after compiling a procedure
>
> 2. explaining the plan with:
> SQL> l
> 1 select lpad(' ',2*(level-1))||operation||' '||options
> 2 ||' '||object_name
> 3 ||' '||decode(id,0,'Cost = '||position) "Query Plan"
> 4 FROM plan_table
> 5 START WITH id = 0 AND statement_id = 'FRANK'
> 6* connect by prior id=parent_id AND statement_id = 'FRANK'
> SQL> /
> buffer overflow. Use SET command to reduce ARRAYSIZE or increase
MAXDATA.
> SQL>
>
> I tried increasing ARRAYSIZE and MAXDATA to their maximum but the
error msg
> still appears. Please know that the explain plan is only 5 lines
and the
> error message
> is abot 30 lines. Both tasks work fine with SQL*worksheet.
>
> Thanks,
> Frank Siegel
> New Hampshire
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 12:46:23 CDT