pl/sql package

Yes.

Define the exceptions in the package header the reference them from Other packages.

create or replace package my_package as my_public_exception exception;
--

• This exception is now public and can be referenced
• by anyone with permissions to access this package
  --
  end my_package;

Any other procedure, function package or trigger can now use the exception as follows

Declare
Some_var varchar2(10);
Begin
If some_var is null
then raise my_package.my_public_exception;
--

• Notice that the exception is qualified by the name of
• the package it is created in
  --
  exception when my_package.my_public_exception then .... end;

As you can see you need to be careful with the naming of packages and exceptions or your code will rapidly become difficult to read.

		-----Original Message-----
		From:	adoerler_at_acm.org (Andreas Doerler)
[mailto:adoerler_at_acm.org]
		Posted At:	Friday, September 11, 1998 11:04 AM
		Posted To:	misc
		Conversation:	pl/sql package
		Subject:	pl/sql package

		hi,

		can i define a package with (package-)global
		exceptions?

		  <ad>