Perl script working in unix command line, but not working for apache

[Kong, Alan]

Title: Blank

Hi all, I have a problem with perl5.6.1, DBI1.21, DBD::Oracle1.12 and apache1.3.26. My perl script works fine in command line, but not working when I call it through browser.  The followings are the error message from the apache error_log: install_driver(Oracle) failed: Can't load '/opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0-thread-multi/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /opt/perl5/lib/5.6.1/PA-RISC2.0-thread-multi/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 /opt/apache/cgi-bin/alan1.pl line 11 Here is my test perl script: #!/opt/perl5/bin/perl use DBI; #use lib '/opt/perl5/lib'; my $dbh = ''; $myquery = "select user from dual"; die "$DBI::errstr" unless $dbh = DBI->connect ('', 'cuflink', 'cuflink', 'Oracle'); $q = $dbh->prepare($myquery) or die "$DBI::errstr"; $q->execute(); $me = $q->fetchrow; $q->finish; $dbh->disconnect; print "testing...$me", "\n";   Does any one know any trick on this problem?  Thanks in advance, Alan PS:  When I installed apache, it generated a perl test script which points to /usr/contrib/bin/perl instead of /opt/perl5/bin/perl.  Not sure if this is the cost of problem, if so, what should I do?  remove the perl in /usr/contrib/bin?