breezykatt has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am having some trouble installing DBD-Oracle from the PPM. I was able to first install the DBI module. The "Mark for Install" is disabled when I select the DBD-Oracle module though. From the other thread for this issue, it says to try a URL (batch job), which I did, but did not work. I haven't found the steps to simply install this module for use on Windows XP machine. I am running Active Perl. Any help would be appreciated. thanks.

Replies are listed 'Best First'.
Re: Install Oracle DBI DBD
by Generoso (Prior) on Jun 08, 2010 at 19:32 UTC

    I have it installed in Windows XP and it is working fine. You do need to install an oracle client, and I think it has to be version 9i or above.

[reply]
Re: Install Oracle DBI DBD
by mje (Curate) on Jun 08, 2010 at 16:38 UTC

    I've never done this myself so take this with a pinch of salt but you'll need to install the Oracle client libraries on your Windows machine first. Instant Client (free from Oracle) is probably the best bet.

[reply]
      Thanks for the quick response. I did previously install Oracle client 10g. I just assumed all I would need to do is install this module and would work out of the box, so to speak. TNSNames.ora is already setup... 
      #!/usr/bin/perl -w
 use DBI;
 $dbh = DBI->connect('dbi:oracle:sid','username','password')
 or die "Connection Error: $DBI::errstr\n";
 $sql = "select * from samples";
 $sth = $dbh->prepare($sql);
 $sth->execute
 or die "SQL Error: $DBI::errstr\n";
 while (@row = $sth->fetchrow_array) {
 print "@row\n";
 }

      [download]
[reply]
[d/l]
        Looks like it found the correct directory? Do I need to upgrade the perl files within the Oracle directory? Here is the error message:

        C:\>db.pl > db.out Use of :unique is deprecated at C:\oracle\product\10.2.0\db_2\perl\5.8.3\lib/MSWin32-x86-multi-thread/Config.pm line 39.

        Use of :unique is deprecated at C:\oracle\product\10.2.0\db_2\perl\5.8.3\lib/MSWin32-x86-multi-thread/Config.pm line 80.

        Perl lib version (v5.8.3) doesn't match executable version (v5.10.1) at C:\oracle\product\10.2.0\db_2\perl\5.8.3\lib/MSWin32-x86-multi-thread/Config.pm line 32.

        Compilation failed in require at C:\oracle\product\10.2.0\db_2\perl\5.8.3\lib/MSWin32-x86-multi-thread/DynaLoader.pm line 25.

        BEGIN failed--compilation aborted at C:\oracle\product\10.2.0\db_2\perl\5.8.3\lib/MSWin32-x86-multi-thread/DynaLoader.pm line 25.

        Compilation failed in require at C:\oracle\product\10.2.0\db_2\perl\site\5.8.3\lib/MSWin32-x86-multi-thread/DBI.pm line 156.

        BEGIN failed--compilation aborted at C:\oracle\product\10.2.0\db_2\perl\site\5.8.3\lib/MSWin32-x86-multi-thread/DBI.pm line 156.

        Compilation failed in require at C:\Documents and Settings\809271\Desktop\db.pl line 3.

        BEGIN failed--compilation aborted at C:\Documents and Settings\809271\Desktop\db.pl line 3.
[reply]

Back to Seekers of Perl Wisdom