Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: connecting toOracle7 and Oracle9 simultaneously

by mifflin (Curate)
on Jun 03, 2005 at 18:42 UTC ( [id://463364]=note: print w/replies, xml ) Need Help??


in reply to connecting toOracle7 and Oracle9 simultaneously

We currently use DBI to connect to Oracle 7.3.4.5 and 9.2 all the time, and so far, have not encountered any significant problems.
Our DBD::Oracle was compiled using the 7.3.4.5 oci but, we use the Oracle 9.0.1 tnslsnr. Oracle 9.0 seems to be a middle version that can communicate with a 7 and 9.2 database.
You've probably realized this if you have ever attempted to create a database link in Oracle 7 to try and access an object in Oracle 9.2. You can't. However, you can use a 9.0 database is a hopping point. We have many apps here that take advantage of newer database packages by doing this 7->9.0->9.2 database link trick. It's not exactly the most efficient process but if you're desparate like we were...
  • Comment on Re: connecting toOracle7 and Oracle9 simultaneously

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://463364]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-04-25 08:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found