[ale] Any DBI Oracle guys out there?

Tue Jan 18 12:20:58 EST 2005

just different execution environment that may or may not have the right
Oracle environmental variables set. You'll need to set ORACLE_HOME and alike
inside your script, otherwise, the CGI script has no idea. When you run from
shell, the script gets it from the current $shell.

-----Original Message-----
From: ale-bounces at ale.org [mailto:ale-bounces at ale.org]On Behalf Of Armsby
John-G16665
Sent: Tuesday, January 18, 2005 12:05 PM
To: 'ale at ale.org'
Cc: 'john.armsby at mindspring.com'
Subject: [ale] Any DBI Oracle guys out there?

I have a little test script which runs from the shell "perl
testOracleObject.pl"  It uses DBI successfully and prints a few records to
the screen. No warnings, works great.

I take the same script, add a little html stuff... and run it directly as a
url from cgi-bin

print"content-type: text/html\n\n";
print("<html><body>");

http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl
<http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl> 

and APACHE 2.0.46 blows up.

Any ideas??  I am stumped.  Next thing to do is post to perl guys.....

John

[Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81]
install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Oracle/Orac
le.so' for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object
file: No such file or directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
[Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81]  at (eval 1) line
3
[Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81] Compilation
failed in require at (eval 1) line 3.
[Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81] Perhaps a
required shared library or dll isn't installed where expected
[Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81]  at
oracleConnectionObject.pm line 54

This email and any attached files herein contain information that is intended only for the use of the individual or entity to whom it is addressed and may contain information that is legally privileged, confidential or otherwise exempt from disclosure under applicable laws. If the reader of this message is not the recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited.

-------------- next part --------------
An HTML attachment was scrubbed...