Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAISE_APPLICATION_ERROR

Re: RAISE_APPLICATION_ERROR

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 29 Jul 1999 19:18:34 GMT
Message-ID: <37aea8e5.116341209@newshost.us.oracle.com>


A copy of this was sent to Nandakumar <nanban_at_my-deja.com> (if that email address didn't require changing) On Thu, 29 Jul 1999 18:52:17 GMT, you wrote:

> Anyone has an idea as to where this PROCEDURE
> RAISE_APPLICATION_ERROR (number,'mesg') would print the message.
> The serveroutpt flag is set.
>
> When this procedure is invoked from within a function, it does not
> print the message anywhere.
>
> When invoked from SQL prompt this is what happens!
> SQL> execute raise_application_error(-20001,'hi')
> begin raise_application_error(-20001,'hi'); end;
>
> *
> ERROR at line 1:
> ORA-20001: hi
> ORA-06512: at line 1
>
> Anything wrong with the above code?
>
> Thanks

lets see the code for your function. I'll bet it has an exception handler with a WHEN OTHERS clause and hence the raised error is being caught and ignored.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 29 1999 - 14:18:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US