| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Transaction Management in PL/SQl
A copy of this was sent to kabilang_at_my-dejanews.com
(if that email address didn't require changing)
On Sat, 19 Sep 1998 16:35:34 GMT, you wrote:
>One of our functions in Oracle PL/SQL requires that it calls a coverup
>procedure. This procedure in turn calls a lot of procedures in different
>packages. Now the requirement is only if all the procedures work perfectly
>without getting into the Exception block (of the respective procedures) at
>all, we need to commit the transaction. Otherwise the transaction must be
>rolled back. Now, the problem is how to monitor whether a nested procedure
>call has been completed without getting into the Exception block. Now what
>happens is it goes to WHEN OTHERS Exception handler and then comes out
>successfully. This is against the requirement. Can anyone help me how to
>monitor whether a nested procedure call has been executed without going to
>the Exception block. I'll be thankful. Yours GK
>
you can't do this, you either need to recode the lower level routines or change the requirement.
Exceptions in any language (pl/sql, Ada, C++, Java, etc) don't mean 'error' they mean exception, something happened please deal with it. If the code you are calling has a when others and deals with the exception, as far as anyone is concerned -- no error occurred.
The coders at the lower levels need to code their exception blocks like:
exception
when others then
... code that exists ...
RAISE;
they need to add the RAISE to the end of their exception blocks to keep the exception propagating up the call stack. Once an exception is caught and handled -- its as if it never happened.
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Sep 19 1998 - 14:01:17 CDT
 |
 |