Richard Labutis wrote:
if you have a system with multiple versions of oracle and using Perl DBI and
DBD modules.
how to use/setup the DBD module to work on any version of oracle. In
otherwords which oracle environment am i going to use?
the make file will hard code the full path of the libraries into the
binaries.
Option (1): pick one Oracle client version, higher the better, always
use that client when using the Perl scripts.
Option (2): use PREFIX when running Makefile.PL to create a separate
DBD::Oracle installation per client version in separate directories
(it'll compile against whatever you have ORACLE_HOME [+PATH
+LD_LIBRARY_PATH] set to at the time), and then later remember to set
PERL5LIB as appropriate as well when you change Oracle client
environment variables, so the appropriately linked DBD::Oracle gets loaded.
(no doubt there are several more options)
what happens when you need to create the dbi/dbd module for another system
that does not have the version of oracle on the system that has the IBM C
compiler?
Using PAR might be one option, but as suggested in another post, using
Instant Client is a fairly attractive option due to its simple
installation (i.e. just drop it in a suitable directory).
--
Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool