I have a number of packages that control EXCEPTIONS the same the way.
The instructions in the EXCEPTION section are
WHEN NO_DATA_FOUND THEN
WHEN DUP_VAL_ON_INDEX THEN
WHEN OTHERS THEN
There is a global package which contain the definition of constants use in the various packages. I would like to define a procedure or function in this package that handles all the exception. Instead of writing the same code I would just need to call it.
How can it be done.
Thanks in advance