On 2009-12-14 07:18:41 -0500, jeff wrote: > I need to connect simultaneously to both Oracle 8 and oracle 10 from the > same script using 'external' connection (ie, no username or password). > The Oracle libraries, from my experimentations, are not compatible for > external connections. Oracle 8 uses system ID and Oracle 10 uses wallet > and they do not overlap. [...] > Anyway, since Oracle DBD can only be built against 1 at a time , this > presents a problem. I have been trying to use DBI Proxy in a PAR > standalone for Oracle 8 connections and the usual setup for Oracle 10 > connections with some limited success. > > What would be ideal would be to have 2 different Oracle DBD connections > from within the same perl build. Any suggestions or ideas for potential > solutions out there ?
Split the script into two processes: One of them talks the Oracle 8 DB and the other one talks to the Oracle 10 DB. Let them communicate over a pipe or socket. hp -- _ | Peter J. Holzer | Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd
signature.asc
Description: Digital signature