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

From: Winston Ying Mei <ymei_at_accessv.com>
Date: Tue, 20 Apr 1999 01:19:06 GMT
Message-ID: <371BE443.81713947_at_accessv.com>


It seems you can connect to SQL* and then increase the buffer from the menu. Try it around.

Ying Mei

Oracle developer

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 - 03:19:06 CEST

Original text of this message