Thanks!
On Oct 2, 2009, at 12:59 PM, John Scoles wrote:
Hmm interesting question.
My guess is that the two should not mix within apache so yes you
can do this in you program/s without the two conflicting.
One thing to check is to see if your apache server is using Mod_perl
and if it is in the start_up.pl you can set the ORACLE_HOME and
LD_LIBRARY_PATH
there and apache will use it for any perl it calls it makes. So you
will not have to add those lines of code in all your .pl scripts.
Likewise PHP should just keep working with the ENV settings that
apache is running under
Cheers
John Scoles
as one would be using
Bruce Johnson wrote:
here's my problem. Due to some ancient database infrastructure I
need to use an old version of DBD::Oracle compiled against an
Oracle 8i client libs.
We're setting ORACLE_HOME and LD_LIBRARY_PATH to be inherited from
Apache.
The problem is that this completely borks PHP/Oracle connection,
since the current version of PHP won't work with the old version;
it works fine with 10 or 11 Instant client.
If I reset those two env vars in my programs, via
$ENV{'ORACLE_HOME'} = <path to old version of oracle>
$ENV{'LD_LIBRARY_PATH'} = <path to old version of oracle>
Will this suffice to allow php (via Apache) to use the new client
and DBD::Oracle to use the old?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs