> -----Original Message-----
> From: Jay Strauss [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 06, 2001 9:03 AM
> To: [EMAIL PROTECTED]
> Subject: DBD-oracle works but not from Mod-perl
>
>
> 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).
you should have been able to find a number of threads that address basic
DBD::Oracle problems under mod_perl, though I haven't seen this particular
ORA_OCI.al error before.
at any rate,
FAQ of the week
o I'm trying to use DBD::Oracle under mod_perl on linux - it works
just fine standalone, but not under mod_perl...
There is a problem with the Makefile produced by DBD::Oracle 1.03
and above: it does not pass the -R$ORACLE_HOME/lib option to the
linker. There are a few solutions, requiring either running
ldconfig or editing Makefile.PL - all are can be found in the
mod_perl or DBI users list archives ([16] for example)
[16] http://forum.swarthmore.edu/epigone/modperl/grahsehspor
HTH
--Geoff
> 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