error while running perl using oracle 1

[rookie23]

F:\crm\2005\bmwcrm\Perl\daily>extractRR.pl
install_driver(Oracle) failed: Can't load 'F:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at F:/Perl/lib/DynaLoader.pm line 206.
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 F:\crm\2005\bmwcrm\Perl\daily\extractRR.pl line 31

also a window opened showing "The Procedure entry point OCIEnvNlsCreate could not be located in the dynamic Link library OCI.dll


Please advice

Thanks

 

[dmazzini]

It seems to be DBI module problems.

Can you check if you can run another script that have acess to the Database.

Or Could ypu post some code...

dmazzini
GSM System and Telecomm Consultant

 

[rookie23]

dmazzini,

here is the code i am trying to use

use lib 'f:\\crm\\2005\\bmwcrm\\Perl';
use strict;
use BMWlib;
use DBI;
use Carp;
use ExchangeMail;

# modification history
# check source code marked with 'XXX' before put it into production

my $DEBUG = 0;
my $exception_flag = 0;
my $num_exceptions = 0;
my @exceptionslist; undef(@exceptionslist);
my $debug = 1;
# connect to db
#my $dbh = DBI->connect("DBI:Oracle:skydevel",ready/ready")
# or die("Can't connect to database", 1);
#$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid",$user, $passwd);
my $dbh = DBI->connect("DBI:Oracle:host=10.7.1.70;sid=DEV","ready, ready")
or die("Can't connect to database", 1);
$dbh->{'AutoCommit'} = 0;
exit;

 

[TrojanWarBlade]

Can you talk to the Oracel DB using something like "toad"?


Trojan.

 

[rookie23]

Trojan,

Connection to Oracle DB through TOAD and sqlplus from c:\ or f:\ is working

Thanks

 

[KevinADC]

see if any of this helps you:

http://aspn.activestate.com/ASPN/CodeDoc/DBD-Oracle/Oracle.html

 

[rookie23]

Thanks All for your Help, DBD-Oracle 1.16 was not working so i copied DBD-oracle 1.06 from another machine we had and now it is working fine

 

[MikeLacey]

Not such a rookie...

Mike

I am not inscrutable.

Want great answers to your Tek-Tips questions? Have a look at faq219-2884