RE: raise_application_error and when others
Date: Wed, 30 Nov 2011 22:52:39 +0000
Ahh...Adric...thank you...a very simple but precise test for this..i wish I would have thought of it:) Thank you...perfect...proves my point,
From: Adric Norris [mailto:landstander668_at_gmail.com]
Sent: Wednesday, November 30, 2011 2:38 PM
To: Chuck Boddy
Cc: tim_at_evdbt.com; oracle-l_at_freelists.org Subject: Re: raise_application_error and when others
I think that's normal behaviour... in essence, raise_application_error is just a slightly fancier version of raise.
2 raise_application_error(-20400, 'This is bad... real bad.'); 3 exception
4 when others then 5 dbms_output.put_line('Panic!');6 end;
PL/SQL procedure successfully completed.
Of course, it's always possible that I'm misinterpreting something. Any chance of sharing the relevant code snippet(s)?
"I'm too sexy for my code." -Awk Sed Fred
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 30 2011 - 16:52:39 CST