Re: exception propogation between packages

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 29 Sep 2007 11:05:01 +0200
Message-ID: <fdl4ft$md7$1@news1.zwoll1.ov.home.nl>

Tim B wrote:
> I'm working with Oracle 10, and it appears that exceptions do not propogate
> from one package to another. Is this true, and if so, is there a way to
> change this?
>
>

Post a sample - exceptions are raised, not propagated.

If A.proc_1 calls A.proc_2, and A.proc2 encounters an error, which is caught by an exception handler, that error is handled. (That's the whole point of having an exception handler).

If you want the error to be reraised (so that the error handler in A.proc_1 pick it up), reraise the error. That is accomplished by the RAISE statement.

For A.proc_2, you may read B.proc_1

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sat Sep 29 2007 - 04:05:01 CDT