Re: raise_application_error and when others
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: Chuck.Boddy@xxxxxxxxxxxxxxx
- Date: Thu, 1 Dec 2011 18:51:23 +0530
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
=============================================
TRUTH WINS AT LAST, DO NOT FORGET TO SMILE TODAY
=============================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
