After seeing of few of Steven Feuerstein's presentations, I'd think it'd be better to take your declaration one step further and make a global reusable error handling package. If you google for: feuerstein error-handling ...you should find the top link to a PDF version of his presentation hosted at quest.com. HTH! GL! Rich > 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. -- //www.freelists.org/webpage/oracle-l