Please do me a favour.
am 04.10.2007 12:29:26 von sivakumarmHi,
I have installed Perl 5.6.1 on my windows XP .After that I have written
a small perl script and it run successfully.
When I execute another script(for connecting database and retreiving
data).It is showing DBI error.So I downloaded dbi module DBI-1.59.tar.gz
From the net and copied the DBI folder under the path C:\Program
Files\PERL\lib
Even though it is throwing the error like
"
Can't locate loadable object for module DBI in @INC (@INC contains:
C:/Program F
iles/PERL/lib C:/Program Files/PERL/site/lib .) at C:/Program
Files/PERL/site/li
b/DBI.pm line 243
BEGIN failed--compilation aborted at C:/Program
Files/PERL/site/lib/DBI.pm line
243.
Compilation failed in require at C:\Perl\dbtest.pl line 6.
BEGIN failed--compilation aborted at C:\Perl\dbtest.pl line 6. "
These is my code
#!/opt/perl5.6.1/bin/perl
use strict;
use DBI;
my $dbh =3D DBI->connect( 'dbi:Oracle:omega',
'omega',
'rez5mip2',
);
my $sql =3D qq{ SELECT indiv_firstname, indiv_lastname FROM ind,usr =
WHERE
ind.ind_cd=3Dusr.ind_cd and usr_login=3D'20224474'};
my $sth =3D $dbh->prepare( $sql );
$sth->execute();
while (@row =3D $sth->fetchrow_array) {
($indfirst, $indlast) =3D @row;
print "$indfirst\n";
print "$indlast\n";
}
$sth->finish;
$dbh->disconnect;
Please help me out to reslove this.
Regards
Sivakumar.M