You can use a single version for remote database access since DBI, like any
OCI application is compiled against the Oracle OCI libraries. For remote
access, the OCI libraries use SQL*Net which can adapt across various
database versions. Different versions of SQL*Net may require different
versions of DBD::Oracle, but you could compile against one version and make
sure to use that ORACLE_HOME (and LD_LIBRARY_PATH, if applicable) when using
DBD::Oracle.
For local access, you may need different versions, since BEQ connections
communicate directly with the running instance and don't have SQL*Net to
mediate.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "David Good" <[EMAIL PROTECTED]>
To: "Dbi-Users@Perl. Org" <[EMAIL PROTECTED]>
Sent: Saturday, April 28, 2001 12:19 AM
Subject: Can DBD::Oracle connect to various versions of Oracle?
> I've been wondering. We support a number of clients running various
> versions of Oracle and I'd like to have just one copy of DBD::Oracle that
> would be able to connect to them all. We currently have some custom Pro*C
> apps and to hear the developers talk about it, they have to be compiled
> alot differently for each version of Oracle they want it to run against.
>
> Is it possible to have one copy of DBD::Oracle that'll work with Oracle 7,
8
> and maybe even 9?
