Is it possible to switch OCI dll version at runtime ?
Using the Oracle Instant client, I have tried to load both 10.2 and 19 OCI dlls during the same process execution, but it fails with << EOCIInitError with message 'Can't initialize OCI. Error -1' >>
When loading just 10.2 or just 19, it works, but when attempting to load both in the same process, even sequentially, closing and freeing all classes related to the 10.2, then calling "OracleHomes.Release" before attempting to access 19, the error occurs.
Is there a way to use different Instant client versions in the same process execution sequentially ?
(and/or better would be a way to load them simultaneously, if possible)
The usage case is access to different Oracle servers, and dance around the client interoperability matrix...
FWIW 10.2 and 11.2 can be loaded sequentially (but not simultaneously).