RE: pl/sql problem

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 06 Jun 2001 15:10:45 -0700
Message-ID: <F001.0031F5AE.20010606150622@fatcity.com>

Thats a pain in the rear errer caused by DBMS_OUTPUT. DBMS_OUTPUT buffers all its data up and then ships it to you at one time. For this reason you need to define the buffer large enough to handle all your output.

In your code, put the line

DBMS_OUTPUT.ENABLE(20000); or some such number to set your buffer. In this case I picked 20,000 for the buffer size.

-----Original Message-----
Sent: Wednesday, June 06, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L

Hi,

i am running following code

declare
cursor c1 is
select nm_enum_data from t_enum_data where id_enum_data in (select distinct id_view from t_acc_usage_1 union
select distinct id_view from t_acc_usage_2 union
select distinct id_view from t_acc_usage_3 );
enum t_enum_data.nm_enum_data%type;
begin
open c1;
loop
fetch c1 into enum;
exit when c1%notfound;
dbms_output.put_line(enum);
end loop;
end;
/

i am getting error:
declare
*
ERROR at line 1:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 91
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at line 16

What might be the reason????????

Thanks
Harvinder
--

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

Author: Harvinder Singh
INET: Harvinder.Singh_at_MetraTech.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).
--

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

Author: Kevin Lange
INET: kgel_at_ppoone.com

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