Bruce Johnson wrote:
I've got to update DBD::Oracle on a production machine (from our
antique 1.17 version to the current one), in the process I'm changing
the Oracle client as well.)
will the proper setting of the environment vars (ORACLE_HOME,
LD_LIBRARY_PATH, etc) and running "update DBD::Oracle" via cpan
suffice or do I have to go in and rip out the old stuff first...
Short answer yes with a but. Long answer No with a Maybe.
Jumping from 1.17 all the way to 1.23 is quite a leap and may not gain
anything from it.
What client are you using with 1.17 and what client do you want to use
with 1.23 and what version of Oracle do you want to connect to are the
big questions to ask and of course what OS are you working in
Unless there is some special features of the later DBD::Oracle that you
want to take advantage of or you are upgrading to ORACLE 10 or 11 I
would just leave it running with 1.17.
The above aside update DBD::Oracle might work if you set the
ORACLE_HOME, LD_LIBRARY_PATH, correctly have the same C compiler that
built your perl.
cheers
John Scoles