RE: raise_application_error and when others

From: Chuck Boddy <Chuck.Boddy_at_gettyimages.com>
Date: Wed, 30 Nov 2011 22:52:39 +0000
Message-ID: <03ED9A05921CD149B3984ABF3F59EE7A1E7B44_at_SEAPXCH10MBX01.amer.gettywan.com>

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,
Chuck

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. SQL> begin
  2 raise_application_error(-20400, 'This is bad... real bad.');   3 exception

  4     when others then
  5        dbms_output.put_line('Panic!');

  6 end;
  7 /
Panic!

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