RE: Problem using Perl DBI-DBD against Oracle
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <gba.oraclel@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Apr 2006 10:28:13 -0500
I have only compiled this on UNIX so I can only guess, but it seems you are
missing an oracle shared library. In my experience various client installs
are missing key libraries that Perl needs and are only found in server
installs. Basically I look for the missing shared libraries on the server
install (same version of course) and copy them down to the client. In the
past when one library was missing, usually others were missing as well so I
tend to copy the entire directory of the missing library down. Unfortunately
I can't remember the directories as I haven't compiled Perl dbd/dbi in over
a year, but it is two different lib directories and a sample directory if I
am not mistaken.
Ken Naim
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of GBA-DBA
Sent: Tuesday, April 04, 2006 10:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Problem using Perl DBI-DBD against Oracle
Hi, I'm trying to run this Perl script against a remote Oracle 10g R1
database. I'm using WinXP and i already have the oracle client software
installed and working.
My Perl version is 5.8.7
DBI version is: 1.50
DBD version is: 1.17
#!perl -w
use strict;
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:maxdev1', 'scott', 'tiger',
{ RaiseError => 1, AutoCommit => 0 } );
print $dbh->selectrow_array(qq{ SELECT 'Hello World' FROM DUAL });
$dbh->disconnect( );
This is the error message i get:
install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:The specified procedure could not be found at
C:/Perl/lib/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at C:\Perl\code\select_dual_short.plx line 9
Any clues about what can be wrong??
Regards
GBA
Other related posts:
