Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pragma Exception Init

Pragma Exception Init

From: Richard Fairbairn <r.fairbairn_at_zetnet.co.uk>
Date: 1998/03/20
Message-ID: <1998032012234076740@zetnet.co.uk>#1/1

I'm trying to redefine ORA-2305. Here's my test code:

declare
user_exep exception;
pragma exception_init (user_exep, -2305);
--etc
--etc

begin
--etc
--etc

exception
when user_exep then
raise_application_error(error_nu, error_ess); end;

What's going wrong? How do I get ORA-2305 to appear when my user_exep is raised?

Thanks

R.W. Fairbairn Received on Fri Mar 20 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US