Re: serverouput buffer overflow

From: yong huang <yong321_at_yahoo.com>
Date: Fri, 11 Aug 2000 15:35:22 -0700 (PDT)
Message-Id: <10586.114429@fatcity.com>

It seems nobody has suggested an easier approach. Here's one from Thomas Kyte:

create or replace procedure p(p_str in varchar2) as
l_str long default p_str;
begin
loop
  exit when l_str is null;
  dbms_output.put_line( substr( l_str, 1, 250 ) );   l_str := substr( l_str, 251 );
end loop;
end;

I've been happily using it for a long time.

Yong Huang
yong321_at_yahoo.com

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ Received on Fri Aug 11 2000 - 17:35:22 CDT