To clear up any confusion about what I mean by 'external' ( since a wallet on Oracle 10 really is 'internal' with 'external' storage ):
The requirements are: Oracle 8 - external authentication - user provide NO user name/password on interface. Oracle 10 - wallet authentication - user provide NO user name/password on interface. The oracle client libraries seem to be mutually exclusive on the above two modes of connection. -------- Forwarded Message -------- From: jeff <j...@roqc.no> To: dbi <dbi-users@perl.org> Subject: Clarify: Different versions of Oracle .so files within single Perl build Date: Mon, 14 Dec 2009 10:24:02 -0500 To clarify - connecting 'internally' (ie, forcing users to provide username & passwords on the GUI ) is not an option - all connections must be 'external'. -------- Forwarded Message -------- From: jeff <j...@roqc.no> To: dbi-users@perl.org <dbi-users@perl.org> Subject: Looking for clever solution: Different versions of Oracle .so files within single Perl build Date: Mon, 14 Dec 2009 07:18:41 -0500 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
