Let me first say that I've never had to do this, but here are several suggestions:

Would suggest that you try renaming one DBD module. Since you're working with multiple boxen, port collision wouldn't be a problem. ENV variables might.

Or, try writing two scripts, one with the path to O7's DBD and the other with O9's, and call them as transfer scripts from your main program.

Take STDIN as SQL and pass it to DBI/DBD, and respond to STDOUT. You'd have to pass the data arrays by SHM, filesystem, or something like that.

Alternately, you could run them as daemons on the individual boxen, and just pass SQL and the stringified response back.

In reply to Re: connecting toOracle7 and Oracle9 simultaneously by samizdat
in thread connecting toOracle7 and Oracle9 simultaneously by bestrafer

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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! —
  • 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:
    & &amp;
    < &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.