Re: :Oracle debugging
From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 07/20/04
- Next message: Tim Bunce: "Re: Oracle 10.1.0.2, RedHat AS, and DBD::Oracle"
- Previous message: Ron Reidy: "RE: Oracle 10.1.0.2, RedHat AS, and DBD::Oracle"
- In reply to: Mark Nettlingham: "RE: :Oracle debugging"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 20 Jul 2004 16:45:03 +0100 To: "Nettlingham, Mark" <Mark.Nettlingham@logicacmg.com>
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:Ron.Reidy@arraybiopharma.com]
> Sent: 19 July 2004 17:07
> To: Nettlingham, Mark; dbi-users@perl.org
> 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:Mark.Nettlingham@logicacmg.com]
> Sent: Monday, July 19, 2004 10:03 AM
> To: 'dbi-users@perl.org'
> 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.
- Next message: Tim Bunce: "Re: Oracle 10.1.0.2, RedHat AS, and DBD::Oracle"
- Previous message: Ron Reidy: "RE: Oracle 10.1.0.2, RedHat AS, and DBD::Oracle"
- In reply to: Mark Nettlingham: "RE: :Oracle debugging"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
