Please do me a favour.
- From: sivakumarm@xxxxxx (Sivakumar Murugan)
- Date: Thu, 4 Oct 2007 15:59:26 +0530
Hi,
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:\ProgramFiles\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 = DBI->connect( 'dbi:Oracle:omega',
'omega',
'rez5mip2',
);
my $sql = qq{ SELECT indiv_firstname, indiv_lastname FROM ind,usr WHERE
ind.ind_cd=usr.ind_cd and usr_login='20224474'};
my $sth = $dbh->prepare( $sql );
$sth->execute();
while (@row = $sth->fetchrow_array) {
($indfirst, $indlast) = @row;
print "$indfirst\n";
print "$indlast\n";
}
$sth->finish;
$dbh->disconnect;
Please help me out to reslove this.
Regards
Sivakumar.M
.
- Prev by Date: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
- Next by Date: Segmentation fault
- Previous by thread: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
- Next by thread: Segmentation fault
- Index(es):
Relevant Pages
|
|
