Re: Simple question..I am running a stored procedure from SQL PLUS

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_at_chartermi.net
Oracle DBA

Go Wings!!!!!!!