When upgrading the version of DBD::Oracle, you'll probably want to make sure that you
use the DBD-Oracle8 ppd file as it was compiled with oci8 instead of oci7. I wasn't
having any problems with any of my scripts using the older version, but I wasn't doing
anything that complex with it either. If you are getting errors now, it may well be
that it is because of the oci version DBD::Oracle was compiled with.
In order to use the DBD-Oracle8 ppd file, though, you will need to upgrade to Oracle
5.6, With that, you will have to upgrade most if not all of the other modules you may
have installed on that machine. Prior to running the upgrade of Perl, run "ppm query"
to see what you have installed, and write the output to a file or print it. That way
you can make sure that you re-install all of the same modules. There are a few that
show up in "ppm query" that are default installations, so not all of them will will
need to be installed manually. Querying again after installing perl, will tell you
which ones.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 3:36 PM
To: [EMAIL PROTECTED]
Subject: Order of Operations
Hello All,
I'm looking for some guidance in upgrading an application. Currently the
application is running Perl 5.09(515), DBI 1.06, DBD:Oracle .059 and the RDBMS
is Oracle 7. The user wants to upgrade to Oracle 8.1.6. In testing the
application as it stands with Oracle 8.1.6 we are getting numerous errors.
These look like they are probably related to DBI and DBD:Oracle having some
compatibility problems with Oracle 8.1.6. So I'm going to update both modules.
I'm assuming to do this I will also need to upgrade the Perl installation. Is
this correct, and is this the best course of action? What should be the order
of operations?
P.S. This is an NT installation so I'm looking at Active Perl annd all the
latest versions.
Thanks
