Re: global pragma exception init

From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Fri, 9 May 2008 21:47:02 -0400
Message-ID: <9c9b9dc90805091847i1969ed71pa5b60fe6d1af8355@mail.gmail.com>


Yes Kurt that is the way!

On Fri, May 9, 2008 at 4:21 PM, Kurt Franke <Kurt-Franke_at_web.de> wrote:

>
> Hi,
>
> >Is there any way to create a global pragma excetpion init list in PL/
> > SQL
> >
> > For example I have this in a package spec.
> >
> > insert_null_into_notnull EXCEPTION;
> > PRAGMAEXCEPTION_INIT(insert_null_into_notnull,-1400);
> > update_null_to_notnull EXCEPTION;
> > PRAGMAEXCEPTION_INIT(update_null_to_notnull,-1407);
> >
> > i do not want do define them in every package/procedure/function, I
> > want them defined at one place and want every package/procedure/
> > function to use them. Is there any to achieve this? I am not a PL/SQL
> > expert, so pardon my ignorance.
>
> the closest methode to do this in an oracle supported way
> is to put those declarations in a separate package and use it with
> a full qualified name.
>
> create package exc
> as
> insert_null_into_notnull EXCEPTION;
> PRAGMA EXCEPTION_INIT(insert_null_into_notnull,-1400);
> update_null_to_notnull EXCEPTION;
> PRAGMA EXCEPTION_INIT(update_null_to_notnull,-1407);
> end exc;
> /
>
> create procedure use_exc
> as
> begin
> -- application specific code ...
> NULL;
> exception
> when exc.insert_null_into_notnull then
> -- application specific handling
> RAISE;
> end use_exc;
>
>
> regards
>
> kf
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Rumpi Gravenstein

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 09 2008 - 20:47:02 CDT

Original text of this message