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

From: Fred Zimmerman <silversw2000_at_yahoo.com>
Date: 20 Nov 2002 06:42:29 -0800
Message-ID: <a695a242.0211200642.c6c25c4@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 - 08:42:29 CST