Re: Buffer error

set serverout on size 1000000
or
set arraysize 1

Veera

Poosapati Varma wrote:

> 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 Wed Oct 18 2000 - 11:33:15 CDT