RE: :Oracle debugging

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 07/19/04

  • Next message: Michael Peppler: "Re: DBD::Sybase wrong tabular output format ?" 
    Date: Mon, 19 Jul 2004 10:06:47 -0600
To: "Nettlingham, Mark" <Mark.Nettlingham@logicacmg.com>, <dbi-users@perl.org>

    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.

  • Next message: Michael Peppler: "Re: DBD::Sybase wrong tabular output format ?"

    Relevant Pages

    • RE: :Oracle debugging
      ... Subject: Oracle debugging ... Subject: DBD::Oracle debugging ... intended recipient then please promptly delete this e-mail and any ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: Oracle and DBI module file
      ... Oracle and DBI module file ... How does the DBI module know which tnsnames.ora file to ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)