Re: Reraising exceptions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 2 Apr 1999 17:57:25 +0100
Message-ID: <923072330.17791.1.nnrp-03.9e984b29@news.demon.co.uk>

No.

As is stands the statement terminates with an error and will do a statement level rollback.

Possible options:

Wrap the block with another begin....end handle but do not re-raise the error in the outer block.

Include a COMMIT; after the insert.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Charles R. Conti wrote in message <3704E47D.FA2F520E_at_ix.netcom.com>...
>Will the insert take place in this piece of code
>
>DECLARE
> err_num NUMBER;
> err_msg VARCHAR2(100);
>BEGIN
> ...
>EXCEPTION
> ...
> WHEN OTHERS THEN
> err_num := SQLCODE;
> err_msg := SUBSTR(SQLERRM, 1, 100);
> INSERT INTO errors VALUES (err_num, err_msg);
>
> RAISE; /* or RAISE_APPLICATION_ERROR */
>END;
Received on Fri Apr 02 1999 - 10:57:25 CST