Re: Exit from PL/SQL Exception Block

From: Richard Woest <r.a.woest_at_kpn-telecom.nl>
Date: 13 Aug 1998 14:46:30 GMT
Message-ID: <01bdc6c9$28365f20$f12b15ac@tonta000072>

Hello,

You could try the following.

When <exception_name> then
raise_application_error(-20000,' <Your specific error message>')

If exception is raised you will get an dialog box with your error message

NOTE: All ORA-errors between -20000 en -21000 are free to be declared by you.

I hope it works for you :-)

With regards,
Richard

Richard Elliott <Richard.A.Elliott_at_wgp.twc.com> schreef in artikel <35D2E7F9.148C_at_wgp.twc.com>...
> I have a large number of PL/SQL programs that all have EXCEPTION blocks
> in them. I want to exit with a specific return code any time the
> exception block is entered. The "whenever sqlerror exit 99" stmt does
> not seem to work if you have an exception block. How can I exit from the
> exception block. Thanks in advance for your help. Reply to E:Mail or
> news group. Thanks !
>
Received on Thu Aug 13 1998 - 09:46:30 CDT