Hi there,
My problem is i am executing perl script from command prompt to query the Oracle database. It works fine from command prompt.
But if i try to execuite the script by placing it in Apache and calling it through browser it does not execute and gives out following error in error_log
install_driver(Oracle) failed: Can't load '/opt/perl5/lib/site_perl/5.8.8/PA-RISC2.0-thread-multi-LP64/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /opt/perl5/lib/5.8.8/PA-RISC2.0-thread-multi-LP64/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /opt/hpws/apacheNew/cgi-bin/TestDB.pl line 5
>>>>>>>>>>>>>
os : HP-UX srvhp4 B.11.23 U 9000/800
perl 5.8.8 (with threading)
DBI : 1.607
DBD:Oracle - 1.14
>>>>
>>>>>>>>>TestDB.pl
#!/opt/perl5/bin/perl
use DBI;
use CGI;
my $dbh = DBI->connect('dbi:Oracle:', q{websmgr/websmgr@(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP) (HOST=172.18.1.224)(PORT=1521))
(CONNECT_DATA=(SID=WEBS)))}, "") || die "Database connection not made: $DBI::errstr";
my $sql = qq{ select * from EF_DJS_CIRCUIT_ATTENDEES };
my $sth = $dbh->prepare( $sql );
$sth->execute();
while (@data = $sth->fetchrow_array()) {
print"DATA is = "."$data[0]"."\n";
}
$dbh->disconnect();
