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?
Most likly the first one it finds. When your run Makefile.PL It will tell
you which client it is useing.
the make file will hard code the full path of the libraries into the
binaries.
Yest that is how it works. But remember it tis the client libraries. OIC.dll
for win and the .SO files for others
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?
Like I have said in the past you are compiling against a client not a
database. In this case I would install the Oracle instant client
http://www.oracle.com/technology/tech/oci/instantclient/index.html as it is
compatiable (as are most clients) with almost any Oracle database and then
compile your DBD::Oracle against this one.
You do not need an Oracle DB on you server to run DBD:ORACLE actully there
are a large number of reasons why you would not want your Oracle DB and
DBD::Oracle on the same box but I wount go into them here.
cheers John Scoles