If so, did you properly install DBD::Oracle. Did you read the README* files that are part of the distro?
Array BioPharma, Inc.
From: Fuat Anat
Sent: Wednesday, November 09, 2005 2:03 PM
I have the following error message when I try to connect to Oracle 10g DB from perl in Linux. Could you please help me.
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: Kann die Shared-Object-Datei nicht Ã¶ffnen: Datei oder Verzeichnis nicht gefunden at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at ./conn.pl line 18
My program is like following
# the -w turns on various warnings
use strict; # always code strictly or you'll be sorry!
# create a database handle. the syntax for this is very flexible. # the quoted string second argument is of the form USERNAME/PASSWORD. # if the username is "scott" and the password is "tiger", then # the second parameter would be "scott/tiger". # if you want to connect using OS authentication as the current # unix id then you can omit the username and the password but # leave the slash, so the parameter would then be "/" (as shown).
my $data_source = 'dbi:Oracle:myDB';
my $username = 'user';
my $password = 'pwd';
my $dbh = DBI->connect($data_source, $username, $password)
or die "Database connection not made: $DBI::errstr";
Start your day with Yahoo! - Make it your home page!
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.