Re^2: connecting toOracle7 and Oracle9 simultaneously

Unfortunately, the problem is connecting to two different database versions with the same DBD::Oracle, which isn't so easy. The problem is that DBD::Oracle compiles against a specific OCI. The OCIs for Ora7 and Ora9 are very different.

I'm emailed Tim Bunce (the author of both DBI and DBD::Oracle) informing him of this thread. Hopefully, he will have time to respond.

In general, if you think something isn't in Perl, try it out, because it usually is. :-)
"What is the sound of Perl? Is it not the sound of a wall that people have stopped banging their heads against?"

Comment on Re^2: connecting toOracle7 and Oracle9 simultaneously

Replies are listed 'Best First'.
Re^3: connecting toOracle7 and Oracle9 simultaneously by gsiems (Deacon) on Jun 03, 2005 at 17:57 UTC
Disclamer: I haven't tried this with DBD::Oracle so I could be all wet. At work we regularly connect to oracle databases of one version using clients of a different version (i.e. connecting to a 9i or 10g database using an 8 client). The only issue that I seem to recall was trying to access new 8i functionality with an older (7.2 I think) client. As for which clients should work with which databases, there's a "Oracle Client / Server Interoperability Support" matrix out on the Oracle metalink site. Additionally, this note may also help clarify the OCI question a bit. Hope that helps.	[reply]
Re^4: connecting toOracle7 and Oracle9 simultaneously by jhourcle (Prior) on Jun 03, 2005 at 18:35 UTC
The links only help those of us who have accounts on metalink, which is only available to people who know their company's support contract info with Oracle. (and I don't currently work for a company with a CSI) I've used 9.2 client to connect to an 8.1 database, and an 8.1 client to connect to a 7.3.4? (was 7, definately... for some reason, 7.3.4 comes to mind), and I know there are settings in the server so that you can allow older versions of the client to connect, but I don't know how severe the penalty is for doing it in 9.2	[reply]
Re^5: connecting toOracle7 and Oracle9 simultaneously by gsiems (Deacon) on Jun 03, 2005 at 19:30 UTC
Hmmm... too true regarding metalink availability (of course having metalink availability doesn't mean that you can actually find what you're looking for on metalink-- or if you did find it once that you'll ever find it again). Fortunately (in this case) Google to the rescue. WRT the OP, I guess I'd try compiling DBD::Oracle against either the 8.1.7 or 7.3.4 client and then try fauria's suggestion.	[reply]