Re: exception propogation between packages



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?

Exceptions propagate in the same manner in 1gR2 as they did in 6.
No change has been made by Oracle.

If you want to communicate an exception you need to use RAISE or
RAISE_APPLICATION_ERROR. Demos in Morgan's Library at www.psoug.org
under EXCEPTION HANDING.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.



Relevant Pages

  • Re: Dynamic "In" w a Cursor in a Package
    ... field1 not in; ... (include is a comma delimited string). ... error so I switched it to use a type declared in the package. ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)
  • Re: dbms_metadata.get_ddl error / 9206 / solaris8
    ... Invalid value for query or REF CURSOR parameter ... SQL> create view v as select * from t; ... So it looks like my dbms_metadata package is messed up. ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Re: DTS equivalent for Oracle
    ... I'm looking to replace this with a package similar to ... DTS in MSSQL. ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.tools)