Re: raise_application_error and when others
Date: Wed, 30 Nov 2011 21:18:59 +0000
It's probable that the trigger is raising the ORA-20400 exception as specified, and is working just fine, but then the *calling* procedure or code is handling the returned exception from the trigger to log to the error table.
From: Chuck Boddy [mailto:Chuck.Boddy_at_gettyimages.com] Sent: Wednesday, November 30, 2011 02:11 PM To: oracle-l_at_freelists.org
Subject: raise_application_error and when others
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
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 30 2011 - 15:18:59 CST