Hello,
I have this script under, it doesn't work.
I have installed the module DBD-Oracle on my Windows platform, I have a Oracle
client who's working in SQLplus mode.
Please help me, to configure my platform or my perl module to work with Oracle
with a Windows Platform.
######### SCRIPT PERL #########
#!/usr/bin/perl
use strict;
use warnings;
BEGIN {
print join("\n", split(';', $ENV{PATH}));
$ENV{PATH} = $ENV{PATH}.';C:\instantclient_10_2';
}
use DBI;
my %opt = (
dbname => 'MyDb', #this is the DatabaseName in my
tnsnames.ora, I have tested without tnsnames.ora parameters but with the
<host>, <port> ... for the same result.
dbuser => 'toto',
dbpass => 'toto',
);
my $dbh = DBI->connect(
'DBI:Oracle:'.$opt{dbname},
$opt{dbuser},
$opt{dbpass}
)
or die 'cannot connect to Oracle'."\n";
######### ERROR LOG IN MYCONSOLE #########
install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:La procÚdure spÚcifiÚe est introuvable
at C:/Perl/lib/DynaLoader.pm line 230.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at C:\oracle.pl line 14
#########
Thanks for your Help.
This message and any attachments (the "message") is intended solely for the
addressees and is confidential. If you receive this message in error, please
delete it and immediately notify the sender. Any use not in accord with its
purpose, any dissemination or disclosure, either whole or partial, is
prohibited except formal approval. The internet can not guarantee the integrity
of this message. Talend shall not therefore be liable for the message if
modified.
