From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Simple question..I am running a stored procedure from SQL PLUS
Date: Wed, 8 Aug 2001 18:26:45 +0200
Message-ID: <997288007.16492.0.pluto.d4ee154e@news.demon.nl>
References: <92a0e580.0108071547.26d135af@posting.google.com> <Xns90F6E79B14DC9gnuegischgnueg@130.133.1.4> <92a0e580.0108080708.221bbd92@posting.google.com>
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: news.demon.nl 997288007 pluto:16492 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 26



"Manoj Nair" <debo_nair@yahoo.com> wrote in message
news:92a0e580.0108080708.221bbd92@posting.google.com...
> 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....


Serveroutput is buffered. If you have less than <buffer size> bytes to
write, you will get them after your procedure completes.
IMO, there's no need to shout, this is a documented feature.

Regards,

Sybrand Bakker, Senior Oracle DBA