Re: Stored Procedure Question
Date: Thu, 27 Sep 2001 16:14:28 +0200
Message-ID: <3bb33423$1_at_gaspra.oss.akzonobel.nl>
In your exception handling you could use utl_file to write messages to file before or after you have rollbacked. Another way is using an error table where you write your messages after having rollbacked.
something like this:
BEGIN <block_x>
debug_message := 'block_x';
....
EXCEPTION
when others then
ROLLBACK; insert into error_table values(debug_message); commit; RAISE;
END; Hth
Marc
"Matthew A. Givens" <m3corps_at_earthlink.net> wrote in message
news:MH6s7.13792$W83.1379671_at_newsread2.prod.itd.earthlink.net...
> We're using Oracle stored procedures, and we use exception handlers so we
> can rollback in case of errors. The problem is that the stored procedure
> name and row number where the error occurred is always the exception
handler
> of the uppermost stored procedure. Is there a way we can keep the ability
> to rollback on database error but have the location of the database error
> correctly reported?
>
> Matthew A. Givens
>
>
Received on Thu Sep 27 2001 - 16:14:28 CEST