DBD-oracle works but not from Mod-perl

[Jay Strauss <jj...@yahoo.com>]

Hi mod_perl,

I have a problem, I've installed DBI & DBD-Oracle.  I have read and searched
all over for an answer and have only found one message with the same problem
(but no reply). It all works fine from a regular perl script (i.e. I can
connect and query fine).  But when I try to
do if from Mod_Perl I get the following:

*** Can't locate auto/DBD/Oracle/ORA_OCI.al in @INC (@INC contains:
/usr/local/apache/lib/perl /usr/local/lib/perl5/5.6.0/i686-linux
/usr/local/lib/perl5/5.6.0 /usr/local/lib/perl5/site_perl/5.6.0/i686-linux
/usr/local/lib/perl5/site_perl/5.6.0 /usr/local/lib/perl5/site_perl .
/usr/local/apache/) at
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux/DBD/Oracle.pm line 48 ***
DBD::Oracle initialisation failed: at /usr/local/apache/perl/SqlQuery.pl
line 84. at /usr/local/apache/perl/SqlQuery.pl line 32

- Linux (RedHat kernel 2.2.16)
- apache - 1.3.19
- mod_perl-1.25
- DBD-Oracle-1.06
- All the oracle software is v8.1.6
- The Apache/mod_perl machine is a client (i.e. my database server sits
along the network)
- Mod_perl WORKS, I can server up dynamic pages
- I edited the DBD-Oracle Makefile and included my LD_RUN_PATH =
(oracle_home)/lib like it says in the doc.
- I don't have an ORA_OCI.al file anywhere on my system, so I can't point it
to it (or copy it to my @INC)

Any Help???
thanks
Jay




_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com