Direct mode and oci mode in parallel -> alternated connection closing

[b-b]

Hello,
if you have want to use two connections, one in direct-mode and one in oci-mode, they are closed alternated.
This is quite bad if you work with transactions (-> rollback).
Is it possible to support both connection types in parallel without closing?

Kind regards,


Bernd

[AlexP]

Hello,

Now you cannot connect to Oracle simultaneously in different modes (OCI and Direct).
We know about this problem, we are working on it.

[dados]

Also if you open one direct session and call DetectOCI and open another direct session then the first direct session is closed...

[AlexP]

Hello,

DetectOCI is an internal method not designed for calling from an application. Thereafter, access to this method will be closed.

[sinys]

We use DetectOCI and InitOCI like

Code: Select all

            try
              if not LoadedOCI then
                DetectOCI;
            except
            end;

            try
              if not OCIInited then
                InitOCI;
            except
            end;

for obtaining OracleHomes and TNS Names list.
How we can obtaining TNS Names if you make DetectOCI private?

Speed of call DetectOCI between 300msec and 1sec. If you can increase speed of this procedure, please do it because it affects on application start speed.

[AlexP]

Hello,

As I wrote earlier, these methods won't be available in the next version, therefore you will have to define the presence of installed clients by yourself. You can define the presence of installed clients by analyzing the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE registry branch