Re: SQL Worksheet: Bufferoverflow

Manfred Pruntsch wrote:

> Hi all,
>
> I used too many DBMS_OUTPUTs in SQL Worksheet (9.0.x). Thats why I got a
> bufferoverflow error:
> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
>
> ORA-06512: at "SYS.DBMS_OUTPUT", line 35
>
> ORA-06512: at "SYS.DBMS_OUTPUT", line 198
>
> How Do I increase the limit for the buffer? I'm sure that its possible but I
> don't know where a how I have to do it.
>
> Are there anybody who can give me an advice?
>
> Many thanks in advance.
>
> Manfred

[Quoted] [Quoted] I've got what I think is a better idea. Drop the DBMS_OUTPUT calls in your code. They do not belong in any code after debugging.

If you think you need them then ask us how to provide the functionality in the correct manner.

For the time being try:

SQL> exec dbms_output.enable(1000000);

But, in general, you should not be using this procedure.

Daniel Morgan Received on Wed Jan 15 2003 - 00:19:22 CET