Unless you need to exploit new features of the database
that will not work from Perl without linking in the newer libraries,
you don't need to reset your ORACLE_HOME.
Just connect to the 9i database with the 8i libs.
I use 8.1.7 build of DBD::Oracle to connect to 7.3.4, 8.0.4,
8.0.6, 8.1.6, 8
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
When installing new releases of Oracle I have found that you need to recompile
the DBD for the new release. In some cases the new DBD may be backward
compatible with the older release of Oracle.
I have thought about having different perl or DBI
Does anybody know if it's possible to have many Oracle client versions use
Perl DBI? I recently upgraded one of our servers from 8.1.7 to 9.2.0.
Now if I run perl scripts with the 8.1.7 environment it works, but if I
set it to 9.2.0 it doesn't.
If I have to make the perl modules again, does that