>
> people have problems with the Oracle DBD driver and 'SetHandler
> perl-script' See http://mathforum.org/epigone/modperl/lumfrahku
>
sorry, but I don't have the old thread in my inbox, so I can't reply
to it.
when you chose to print out ORACLE_HOME from Oracle.pm you were
actually looking in the wrong place. DBD::Oracle requires that
ORACLE_HOME (and any other stuff like NSL_LANG stuff) be in %ENV when
DBD::Oracle is compiled (read: first use()d or loaded on demand by
DBI.pm).
so, you need to make sure that wherever that load happens %ENV is
properly set.
I'm not sure what's possible now with mod_perl 2.0 wrt startup.pl and
<Perl> blocks, but you might want to do something like put that BEGIN
block in your startup.pl instead, followed by
use DBD::Oracle;
use DBI;
or play with the profile for root, nobody, /etc/profile etc to make
sure that $ENV{ORACLE_HOME} and friends get populated properly.
you also might want to remove the NSL stuff for the moment and see if
you can get things working without it. IIRC there was some stuff on
the DBI users list (a _very_ long time ago) where NSL in %ENV was the
issue, so maybe boiling down stuff will help you locate the problem
(and help us see what is required on the mod_perl side in order to fix
things).
HTH
--Geoff
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
