Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL - Any way to force exit?
A copy of this was sent to grth_at_my-dejanews.com
(if that email address didn't require changing)
On Thu, 22 Apr 1999 12:00:27 GMT, you wrote:
>
>
>I am writing a PL/SQL error logger.
>It usually logs the error and continues, but some errors are fatal.
>
>With fatal errors, I would like to end processing completely, and
>exit the current PL/SQL run.
>Is this possible? - all our procedures are written with
>WHEN OTHER THEN...
>blocks, which catch any exceptions I throw.
>
thats too bad. When others then is the worst plsql programming construct -- I wish we didn't allow for it actually. You are saying "ignore all errors, no problems".
If you catch the exceptions and don't reraise them -- then no, there is no way to 'exit' plsql.
>Thanks in advance
> Grth
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities