global pragma exception init

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Fri, 9 May 2008 14:04:01 -0400
Message-ID: <1c8f76b90805091104r41bbe71bv7abdb159296855e8@mail.gmail.com>


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;

PRAGMA EXCEPTION_INIT (insert_null_into_notnull, -1400);

update_null_to_notnull EXCEPTION;

PRAGMA EXCEPTION_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.

thanks

Deen

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 09 2008 - 13:04:01 CDT

Original text of this message