From: mpir@bellsouth.net (Joe Maloney)
Newsgroups: comp.databases.oracle.server
Subject: Re: Simple question..I am running a stored procedure from SQL PLUS
Date: 8 Aug 2001 12:41:52 -0700
Organization: http://groups.google.com/
Lines: 33
Message-ID: <d17bad25.0108081141.7c8ea12a@posting.google.com>
References: <92a0e580.0108071547.1fc737a4@posting.google.com> <99ab87b0.0108080450.6de41c62@posting.google.com> <nsZ8jiADuTc7EwCg@peterfinnigan.demon.co.uk>
NNTP-Posting-Host: 199.15.61.5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997299713 4139 127.0.0.1 (8 Aug 2001 19:41:53 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 19:41:53 GMT


for what it is worth, I usually put 'dmbs_output.enable(1000000);' as
one of the first line in my procedures as well as 'set serveroutput
on'.


Pete Finnigan <pete@peterfinnigan.demon.co.uk> wrote in message news:<nsZ8jiADuTc7EwCg@peterfinnigan.demon.co.uk>...
> Hi
> 
> No i meant what i typed, its worth setting the default buffer size to
> 1000000, the maximum, otherwise it remains at the default size of 20000
> bytes.
> 
> You can do either syntax, but if your output exceeeds the minimum it
> will just stop.
> 
> cheers
> 
> Pete
> Pentest Limited
> 
> In article <99ab87b0.0108080450.6de41c62@posting.google.com>, Tom Best
> <tombest@firstusa.com> writes
> >I hope you mean you did:
> >
> >   set serveroutput on
> >
> >right?
> >
> >debo_nair@yahoo.com (Manoj Nair) wrote in message news:<92a0e580.0108071547.1fc7
> >37a4@posting.google.com>...
> >> so i do a SQL> EXEC my_sp..I have dbms_output statements in code and i
> >> have also set serverout on ..but it doesn't print the messages what am
> >> i missing?