GENERIC PL-SQL EXCEPTION HANDLER

 Hello everyone,

We are trying to write a generic error-handling function. We have a few questions

1. Is there a unique number associated with each exception ( say UTL_FILE.READ_ERROR ) which we can trap in a pl-sql variable ?
2. We were planning to log the following attributes in the genric error handler - sqlcode - function where exception was recd - exception_no ( if possible ) - exception_desc - key being processed - date/time of error

   Any other field which you all find would be worthy of being cpatured ?

c) Any pointers to URLs which deal with the above ?

Thanks for your help and have a great day.

regards,
judederick
:-)
--

We all must be the change we want to see in this world - MG

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 16 1999 - 15:25:13 CDT