Buffer overflow with SQL*Plus

From: Frank Siegel <NorthernSnow_at_worldnet.att.net>
Date: Fri, 1 Oct 1999 11:57:40 -0400
Message-ID: <7t2m2d$p5k$1@bgtnsc03.worldnet.att.net>

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 Received on Fri Oct 01 1999 - 10:57:40 CDT