Re: ORU-10027: buffer overflow, limit of 2000 bytes

Hi

Inside your procedure or package - increase the buffer size to some value - not sure what the max is - as follows

DBMS_OUTPUT.ENABLE(10000); This example value makes the output buffer size 10000 bytes as opposed to the default 2000.

Cheerio
Kugendran Naidoo
Independant Oracle DBA

> Alan Lee wrote:
>
> > When I tried to execute the stored procedure, I get this error from
> > SQL Plus 8.0 (Oracle 8.04 on NT server).
> >
> > ERROR at line 1:
> > ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
> > ORA-06512: at "ALANLEE.SYNC_TABLES", line 159
> > ORA-06512: at line 1
> >
> > Should I increase the SQL Plus environment parameters ? If so, what and
> > how ? Can anyone help me on this ? Thanks in advance.
> >
> > Alan Lee
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 20 1999 - 14:32:33 CEST