Thanks Ron, Just as I was getting trace() to work, one of my Oracle guys came along and noticed that ORACLE_HOME was set wrong in the HOME0 reg key. While it was correct in HOME1, and SQLPLUS could use that particular home, it appears that DBD::ORACLE only looks in the HOME0/ORACLE_HOME var.
Was surprised to not get an errstr error, though! Mark -----Original Message----- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: 19 July 2004 17:07 To: Nettlingham, Mark; [EMAIL PROTECTED] Subject: RE: :Oracle debugging I don't think there is anything in DBD::Oracle, but you can use trace() in the DBI module. ----------------- Ron Reidy Senior DBA Array BioPharma, Inc. -----Original Message----- From: Nettlingham, Mark [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 10:03 AM To: '[EMAIL PROTECTED]' Subject: DBD::Oracle debugging Hi all, I was wondering if there's a way of enabling DBI's internal debugging? Essentially, I'm getting a fail when connecting to an Oracle Database, but no $DBI::err, or $DBI::errstr is being produced - both are null. This is especially frustrating as it only happens on one of two mirrored databases. It also occurs when I attempt to connect to a nonexistant server. I just want to see how far DBI gets before it fails - is it getting to the TNS info? If so, can it connect? TIA Mark This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. 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. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
