Re: perl DBD::Oracle and external password store

  • From: John Scoles <scoles@xxxxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Mon, 15 Dec 2008 09:32:46 -0500

I checked the OCI docs and there is noting special DBD::Oracle has to do to use this store. It just has to be properly configured and you have to use a version of DBD:ORacle over 1.17 and a 10 client.
Looking into the code a little more DBD::ORacle before 1.17 uses the old deprecated Proc connection methods to set up the environment. Later versions use the newer OCIEnvNlsCreate methods which 
should be compatible with the store

Cheers
John Scoles

Jared Still wrote:

Wrong list.
You need to go to http://lists.cpan.org/, find the dbi-users list, and sign up for that. 

No idea if the external password store works with it.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Fri, Dec 12, 2008 at 2:34 PM, Wang, Tao <twang@xxxxxxxxxx <mailto:twang@xxxxxxxxxx>> wrote: 

    I am trying to use perl DBI to connect oracle databases using the
    secure external password store introduced in oracle 10gR2. It
    works great when I use sqlplus connect after setting up the wallet
    and sqlnet.ora. And jdbc thick driver [jdbc:oracle:oci8] seems to
    be working fine with external password store as well.  but I can
    not get it to work using perl DBI module, and I keep getting
    invalid username/password, or invalid names …  Does anyone know if
    the perl DBI/DBD module work with external password store? Anyone
    has some experience with it? Any suggestion is great appreciated!


    I tried it on DBD:ORACLE version: 1.15   DBI version: 1.42 with
    oracle 10g2 client installed.


    Thanks,

    Tao



--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2008