Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: exception propogation between packages

Re: exception propogation between packages

From: William Robertson <williamr2019_at_googlemail.com>
Date: Sat, 29 Sep 2007 05:04:52 -0700
Message-ID: <1191067492.655258.14000@19g2000hsx.googlegroups.com>


On Sep 29, 10:05 am, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> 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...

Propagation is a valid term for the behaviour by which exceptions work their way up the calling tree.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/errors.htm#LNPLS00706

I agree though that there is no such cross-package limitation. An example would help. Received on Sat Sep 29 2007 - 07:04:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US