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 13:49:56 +0100
Message-ID: <WcEw$JA0VTc7Ewnm@peterfinnigan.demon.co.uk>
References: <92a0e580.0108071547.1fc737a4@posting.google.com>
 <tn28m3inctej08@corp.supernews.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 997275520 nnrp-08:9801 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: 31


HI

in your sqlplus session type

SQL> set serveroutput on size 1000000
SQL> exec my_sp....

then you will see output.

cheers

Pete Finnigan
Pentest Limited

In article <tn28m3inctej08@corp.supernews.com>,
tskumar011@rediffmail.com writes
>PRINTER?
>
>Manoj Nair wrote:
>> 
>> 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?
>
>
>--
>Posted via CNET Help.com
>http://www.help.com/
 
-- 
Pete Finnigan