On Tue, Jul 20, 2004 at 08:53:17AM +0100, Nettlingham, Mark wrote: > 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.
A patch to fix the Win32 registry code in Makefile.PL to do-the-right-thing (probably means using LAST_HOME, which is currently doesn't) would be *greatly* appreciated. Please use and patch against: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc5-20040715.tar.gz > Was surprised to not get an errstr error, though! Probably a DBI bug that was fixed in 1.43. Tim. > 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.
