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_at_news.demon.nl>
"Manoj Nair" <debo_nair_at_yahoo.com> wrote in message
news:92a0e580.0108080708.221bbd92_at_posting.google.com...
> rene.nyffenegger_at_gmx.ch (Rene Nyffenegger) wrote in message
news:<Xns90F6E79B14DC9gnuegischgnueg_at_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 Received on Wed Aug 08 2001 - 18:26:45 CEST