I have a module that (among other thing) cleans up the Oracle error messages from the DBD.
The gist of the subroutine is the following regex: s/(.*)\bat.*/$1/g; I leave it to you to implement. -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Jain, Abhay K, ALABS [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 27, 2005 8:53 AM To: dbi-users@perl.org Subject: Mapping oracle error to text string in case of errors Use of "die" directive along with $sth->errstr prints out all internal errors. Is there any mapping in the package which would allow me to print out a meaningful text based on error returned. Error code (ORA_????) seems to be imbedded in the error string. Abhay This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.