Re: raise_application_error and when others

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Thu, 1 Dec 2011 18:51:23 +0530
Message-ID: <CAJsOtB5QnDLDud4uKz+=wNSFY0KzuqaTTzQX7ioQfV0Q6s6UoQ_at_mail.gmail.com>

I do not think so...
raise_application_error will be raised for the defined.. and when others will be raised for others.. with say dbms_output.put_line you can check the line by execution and you can trap what is missing..

thanks..subodh

On 1 December 2011 02:41, Chuck Boddy <Chuck.Boddy_at_gettyimages.com> wrote:

> Hi,
> I have a trigger that under a condition, I call raise_application_error.
> I also have when others defined to write to an error table passing sqlerrm
> and sqlcode. My understanding is that when the condition is met and
> raise_application_error is called, execution ends in the subprogram. What
> "appears" to be happening, is that raise_application_error is handled THEN
> drops down to when others. Because the record that is written to my error
> table has the sqlerrm and sqlcode that is only populated in my user-defined
> raise_application_error handler(-20400). Is this true, that if you call
> raise_application_error AND have when others defined, the call to
> raise_application_error will then drop down to your when others exception?
> Thanks,
> Chuck
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=============================================
TRUTH WINS AT LAST, DO NOT FORGET TO SMILE TODAY
=============================================


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 01 2011 - 07:21:23 CST