Re: buffer overflow, limit of 2000 bytes (how to get around)

Try :

SET SERVEROUTPUT ON SIZE 1000000 from SQL*PLUS b4 running the block or use

dbms_output.enable(1000000)

within the block.

• Jusung Yang

silversw2000_at_yahoo.com (Fred Zimmerman) wrote in message news:<a695a242.0211200642.c6c25c4_at_posting.google.com>...
> In PL-SQL I run the following SQL Script, and
> get the buffer overflow message; how do I get rid
> of the message, and/or increase the buffer?
>
>
> DECLARE
>
> aDate DATE;
> hType VARCHAR2(4);
> hNo VARCHAR2(4);
> Loc VARCHAR2(8);
>
> CURSOR chRows IS
> SELECT HULLTYPE, HULLNO, LOCATION, ASOFDATE FROM CIMSHIST
> GROUP BY HULLTYPE, HULLNO, LOCATION, ASOFDATE;
>
> BEGIN
> FOR currentCH in chRows LOOP
> DBMS_OUTPUT.PUT_LINE(currentCH.HULLTYPE || ' ' ||
> currentCH.HULLNO || ' ' || currentCH.LOCATION || ' ' ||
> currentCH.ASOFDATE);
> END LOOP;
> END;
> /
> AFDB 1C 701002/S 08-APR-92
> AFDB 1C 701002/S 20-SEP-93
> AFDB 1C 701002/S 03-MAY-94
> AFDB 1C 701002/S 27-DEC-94
> AFDB 1C 701002/S 10-JAN-95
> AFDB 1C 701002/S 05-FEB-96
> AFDB 1C 701002/S 18-APR-96
> AFDB 1C 701002/S 23-APR-96
> ...
> ...
> ...
>
> *
> ERROR at line 1:
> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
> ORA-06512: at line 14
Received on Wed Nov 20 2002 - 14:19:23 CST