From: debo_nair@yahoo.com (Manoj Nair)
Newsgroups: comp.databases.oracle.tools
Subject: Re: Simple question..I am running a stored procedure from SQL PLUS
Date: 8 Aug 2001 08:08:32 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <92a0e580.0108080708.221bbd92@posting.google.com>
References: <92a0e580.0108071547.26d135af@posting.google.com> <Xns90F6E79B14DC9gnuegischgnueg@130.133.1.4>
NNTP-Posting-Host: 172.180.158.87
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997283312 26233 127.0.0.1 (8 Aug 2001 15:08:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 15:08:32 GMT


rene.nyffenegger@gmx.ch (Rene Nyffenegger) wrote in message news:<Xns90F6E79B14DC9gnuegischgnueg@130.133.1.4>...
> >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?
> 
> Have you SET SERVEROUTPUT ON in the sql plus prompt?
> 
> Rene

YES I HAVE SET SERVEROUTPUT ON in the sql plus prompt....