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.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.