Re: Buffer error

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 18 Oct 2000 13:06:43 -0400
Message-Id: <10653.119665@fatcity.com>

Do you ever designate where the output is to go? And do you ever write the = output. It sounds like the output buffer is getting full if lines and = never written or cleared.
Please correct my if I'm in left field.
ROR =AA=BF=AA
>>> psgkv_at_YAHOO.COM 10/18/00 12:55PM >>>
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||' =20
'||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/=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Poosapati Varma
INET: psgkv_at_yahoo.com=20

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 Wed Oct 18 2000 - 12:06:43 CDT