Re: ora-20000
From: Lutz Heermann <wkst1.ik6_at_mchp.siemens.de>
Date: Thu, 19 Nov 1998 14:14:25 +0000
Message-ID: <365427C1.E28A3D7D_at_mchp.siemens.de>
Date: Thu, 19 Nov 1998 14:14:25 +0000
Message-ID: <365427C1.E28A3D7D_at_mchp.siemens.de>
Hi Alvin,
You can find the header from dbms_output in <OracleHome>\RDBMS<Version>\ADMIN\dbmsotpt.sql
Take a look at dbms_output.enable for the buffer problem.
Lutz
Alvin Huang wrote:
>
> Hi,all
>
> I got an error when I run my PL/SQL
>
> ORA-20000: ORU-10027 : buffer overflow, limit of 2000 bytes
> ORA-06512: at "SYS.DBMS_OUTPUT", line 100
> ORA-06512: at "SYS.DBMS_OUTPUT", line 59
> ORA-06512: at line 43
>
> what can I do for this??
>
> by the way, how can I find out DBMS_OUTPUT's function
> eg, put_line .......
>
> Best Regards
>
> Alvin Huang 11/19
Received on Thu Nov 19 1998 - 15:14:25 CET