Have you considered using database links? Instead of 2 connections, you could just do everything thru oracle 10.
-----Original Message----- From: jeff [mailto:j...@roqc.no] Sent: Monday, December 14, 2009 5:19 AM To: dbi-users@perl.org Subject: Looking for clever solution: Different versions of Oracle .so files within single Perl build 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. I need to stress that this is NOT an option. I have no say in this regardless of how insecure it may sound. 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 ? Thanks. Jeff
