Re: raise_application_error and when others

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@xxxxxxxxxxxxxxx> 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


Other related posts: