[ale] Any DBI Oracle guys out there?

Tue Jan 18 12:22:09 EST 2005

I've been messing with it for the last couple weeks.  What happens if
you run the script by hand...

./testOracleObject.pl 

That'll tell you if you have a perl syntax problem.  Comment out any
insert or update commands just to be on the safe side also.

Thus spake Armsby John-G16665 (John.Armsby at motorola.com):

>    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>");
>    
>    [1]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/Oracle.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
> 
> References
> 
>    Visible links
>    1. http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl

> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale

:wq!
---------------------------------------------------------------------------
Robert L. Harris                     | GPG Key ID: E344DA3B
                                         @ x-hkp://pgp.mit.edu
DISCLAIMER:
      These are MY OPINIONS             With Dreams To Be A King,
       ALONE.  I speak for              First One Should Be A Man
       no-one else.                       - Manowar

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature