RE: :Oracle debugging

From: Mark Nettlingham (Mark.Nettlingham_at_logicacmg.com)
Date: 07/20/04

  • Next message: Christian Stalp: "dbi:Adabas" 
    To: "'Reidy, Ron'" <Ron.Reidy@arraybiopharma.com>, dbi-users@perl.org
Date: Tue, 20 Jul 2004 08:53:17 +0100

    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: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: Christian Stalp: "dbi:Adabas"

    Relevant Pages

    • RE: oracle delete has no effect
      ... did you commit the transaction before you ran your Perl program? ... oracle delete has no effect ... > sender of the delivery error by replying to this message, or notify us by ... intended recipient, please be aware that any disclosure, copying, distribution ...
      (perl.dbi.users)
    • RE: DBI->data_sources(Oracle)
      ... As far as I understand DBD::Oracle, ... This E-mail message is for the sole use of the intended recipient ... you are not the intended recipient, please contact the sender by reply ...
      (perl.dbi.users)
    • RE: how to get datatype of columns of a table in perl script
      ... given a valid connect to Oracle: ... the perl script successfully gets rows from oracle database ... PRIVATE COMPANY INFORMATION. ... If you are not an intended recipient of this e-mail, ...
      (perl.dbi.users)
    • RE: Insights into DBI->connect differences
      ... You also should set your oracle environment using the shell script ... the sender of the delivery error by replying to this message, or notify ... This electronic message transmission is a PRIVATE communication which contains ... intended recipient, please be aware that any disclosure, copying, distribution ...
      (perl.dbi.users)
    • RE: Connect to Oracle
      ... Subject: Connect to Oracle ... This electronic message transmission is a PRIVATE communication which ... Please notify the sender of the delivery ... intended recipient, please be aware that any disclosure, copying, ...
      (perl.dbi.users)