From: Phil Singer <psinger1@chartermi.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Simple question..I am running a stored procedure from SQL PLUS
Date: Wed, 08 Aug 2001 22:41:39 -0400
Organization: orecreeksystems
Message-ID: <3B71F863.A5D6E30B@chartermi.net>
X-Mailer: Mozilla 4.05 [en] (Win95; U)
MIME-Version: 1.0
References: <92a0e580.0108071547.7bf22e71@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: newsabuse@supernews.com
Lines: 26


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?

One possibility is that you are raising an exception before any of
your dbms_output statements can execute.  So add to your
declarative section something like

     errtxt   varchar2(512);

And to your exception handler something like

     when others then  ----if not already present
        errtxt := sqlerrm;
        dbms_output.put_line(errtxt);

And this possibility should be covered.


-- 
Phil Singer                |    psinger1@chartermi.net
Oracle DBA

Go Wings!!!!!!!