raise_application_error and when others

  • From: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 30 Nov 2011 21:11:17 +0000

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


Other related posts: