RE: Buffer error

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Thu, 19 Oct 2000 17:10:44 -0400
Message-Id: <10654.119813@fatcity.com>

The other answers about set serverout are correct, but I'd also like to point out that you are not closing your cursor. Diana

-----Original Message-----
From: Poosapati Varma [mailto:psgkv_at_yahoo.com] Sent: Wednesday, October 18, 2000 12:56 PM To: Multiple recipients of list ORACLE-L Subject: Buffer error

Hi guys,

How do we solve this problem?
i have a small procedure as below with 100 records,

CREATE OR REPLACE PROCEDURE EMP_LOOP_DAT as V_table_name tc_tang_tables.table_name%type; v_descr tc_tang_tables.descr%type;
cursor c1 is
  select table_name,descr from tc_tang_tables; BEGIN
   open c1;
   loop

      fetch c1 into v_table_name,v_descr;
      dbms_output.put_line(v_table_name||'  
'||v_descr);
      exit when c1%notfound;

end loop;
end emp_loop_dat;

I am getting error message after displaying some records as below,

BEGIN emp_loop_dat; END;

*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

ORA-06512: at "SYS.DBMS_OUTPUT", line 106
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at "TANGRAM.EMP_LOOP_DAT", line 13
ORA-06512: at line 1

What should i do to solve this?

Varma.

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Poosapati Varma
INET: psgkv_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 19 2000 - 16:10:44 CDT