Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem using Perl DBI-DBD against Oracle
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of GBA-DBA
Sent: Tuesday, April 04, 2006 10:03 AM
To: oracle-l_at_freelists.org
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( );
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 04 2006 - 10:28:13 CDT