Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!nntp2.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 02 Feb 2003 16:30:56 -0600
Newsgroups: comp.databases.oracle.misc
Subject: Re: buffer overflow, limit of 2000 bytes (how to get around)
From: weberm@polaris.net (Ubiquitous)
X-Newsreader: WinVN 0.99.10 (beta 4) [de] (x86 32bit)
References: <a695a242.0211200642.c6c25c4@posting.google.com>
Message-ID: <ZeqcneKKzMy9AaCjXTWcpw@comcast.com>
Date: Sun, 02 Feb 2003 16:30:56 -0600
Lines: 12
NNTP-Posting-Host: 68.35.210.171
X-Trace: sv3-tdf9w0+Zk/yFVyTD6Tv8PVA7noQr2IGrEdUyBFeO7kj9+IkqHE8lbaz/EDaj5lTItWklXDZwbEgS0nW!fbuxuawpsyKOWKbiS3ETdCbPDzoeU1Fi7JOXCclEosif72byH7WV95t/Zao9mg==
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:92614
X-Received-Date: Sun, 02 Feb 2003 15:30:16 MST (news.easynews.com)

In article <a695a242.0211200642.c6c25c4@posting.google.com>, 
silversw2000@yahoo.com wrote:

>In PL-SQL I run the following SQL Script, and
>get the buffer overflow message; how do I get rid
>of the message, and/or increase the buffer?

Use the SET SERVEROUTPUT to a really high value (100,000 is the limit?)
or ENABLE.SERVEROUTPUT(100000) (I _think_ that's the command) in the
script.