comment on

That connects to two databases, but it uses the same DBD::Oracle to to it. The OP's problem is that they've got one old and one new that'd (presumably) need two different compiles of DBD::Oracle to talk. This solution might work, but only if v9 is backwards compatible and able to talk to the older v7 instance.

If that's not the case (i.e. v9 can't talk to a v7 DB; I don't know, I'm not an Oracle person):

Compile DBD::Oracle against v9 (setting ORAHOME et al to point at that)
Compile it again against v7, but pass a different PREFIX setting when you run perl Makefile.PL
write one script that does a use lib to point to where you installed the v7 DBD::Oracle and does whatever you need there and saves the results to an intermediary file
write a second script that uses the v9 DBD::Oracle in the default path to process the results from the first

If you can't separate things into two programs (you need to consult the v9 database to know what you need from the v7 DB or what not) things get much more harry. In that case you might could use something like RPC::XML and write a server which provides results from one DB and the main program connects to the other DB and calls across to that XML-RPC server as needed.

Update: Oop, looks like it is the case that they're not compatible by the above post. Looks like you're in harry land.

--
We're looking for people in ATL

In reply to Re^2: connecting toOracle7 and Oracle9 simultaneously by Fletch
in thread connecting toOracle7 and Oracle9 simultaneously by bestrafer

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Syntactic Confectionery Delight
	PerlMonks