DBD::Oracle
am 15.06.2006 09:22:06 von Thiruhai ,
i have one server ant two logins
in one login perl is working fine and in the another login the perl
files are not working
the settings are same for both logins
ld_library_path
shlib_path
perl5lib_path
perllib_path
still it is giving the following error
Can't load '/opt/perl5.005_03/lib/5.00503/PA-RISC1.1/auto/DBI/DBI.sl'
for module DBI: Invalid argument at
/opt/perl5.005_03/lib/5.00503/PA-RISC1.1/DynaLoader.pm line 169.
at /opt/perl5.005_03/lib/5.00503/PA-RISC1.1/DBI.pm line 158
BEGIN failed--compilation aborted at
/opt/perl5.005_03/lib/5.00503/PA-RISC1.1/DBI.pm line 158.
BEGIN failed--compilation aborted at
/opt/perl_local/PA-RISC1.1/Oraperl.pm line 25.
BEGIN failed--compilation aborted at ./perl_test.pl line 2.
my test file
========
#!/usr/local/bin/perl
use Oraperl;
############################################################ ################
# Getting Database information from environment variables
#
############################################################ ################
$dbname=$ENV{ATLAS_DATABASE_NAME};
$userid=$ENV{ATLAS_DATABASE_USER};
$passwd=$ENV{ATLAS_DATABASE_PASSWD};
##################
# oracle login #
##################
($lda = &ora_login("", $userid."\@".$dbname, $passwd)) ||
do { #
oracle login fails
print "Error Connecting Database $dbname : $ora_errstr";
&ora_logoff ($lda);
};
print " Successfully connected to Database : $dbname \n";
&ora_logoff ($lda);
------------------------------------------------------------ ----------------------------------------------------------
can anyone help me on this
i will be greatful to you
thanks,
thiru