Re: PACKAGEs; exception propagation

From: ronald <ronald_at_foo.com>
Date: Sat, 8 Jun 2002 12:22:09 +0200
Message-ID: <adslsp$1sbk2$1@ID-87429.news.dfncis.de>

"Connor McDonald" <connor_mcdonald_at_yahoo.com>

[...]

Thanks Connor, but -- how should I put it -- this was a generic answer.

I am a seasoned IT professional (relatively new to Oracle though), and I _really_ do know everything there is to be known about encapsulation, and "bubbling up" of exceptions. (BTW why can't PL/SQL exceptions propagate like Java exceptions?)

I will clarify:

my question about packages was directed mainly towards development. It's too awkward having to compile the _entire_ package body each time when I make even the smallest change in the smallest procedure in the package body.
my question about exceptions was directed towards propagating exceptions from a procedure P2 to the _calling_ procedure P1. AFAIU, when there is an exception E in procedure P2, P2 exits to host environment. Is there a way to reraise/resend E to the calling procedure P1?

If answers to both of those question is no, then sadly I have to state that PL/SQL needs some serious renovation. Received on Sat Jun 08 2002 - 05:22:09 CDT