Re: ORU-10027: buffer overflow, limit of 2000 bytes
Date: Mon, 19 Apr 1999 18:33:03 GMT
Message-ID: <7ffssv$or2$1_at_nnrp1.dejanews.com>
Try
set long 10000
Sameer
Alan Lee <tienlee_at_mailexcite.com> 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
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 19 1999 - 20:33:03 CEST