From: Pete Finnigan <pete@peterfinnigan.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Simple question..I am running a stored procedure from SQL PLUS
Date: Wed, 8 Aug 2001 14:15:47 +0100
Message-ID: <nsZ8jiADuTc7EwCg@peterfinnigan.demon.co.uk>
References: <92a0e580.0108071547.1fc737a4@posting.google.com>
 <99ab87b0.0108080450.6de41c62@posting.google.com>
NNTP-Posting-Host: peterfinnigan.demon.co.uk
X-NNTP-Posting-Host: peterfinnigan.demon.co.uk:193.237.131.110
X-Trace: news.demon.co.uk 997276721 nnrp-07:11292 NO-IDENT peterfinnigan.demon.co.uk:193.237.131.110
X-Complaints-To: abuse@demon.net
MIME-Version: 1.0
X-Newsreader: Turnpike Integrated Version 5.01 S <ii6xnv5+bmXUulcu5AzBmAM5$X>
Lines: 30


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?
 
-- 
Pete Finnigan