Page 1 of 1
Direct mode and oci mode in parallel -> alternated connection closing
Posted: Fri 02 Aug 2013 14:45
by 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
Re: Direct mode and oci mode in parallel -> alternated connection closing
Posted: Tue 06 Aug 2013 06:28
by 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.
Re: Direct mode and oci mode in parallel -> alternated connection closing
Posted: Sun 15 Sep 2013 16:34
by dados
Also if you open one direct session and call DetectOCI and open another direct session then the first direct session is closed...
Re: Direct mode and oci mode in parallel -> alternated connection closing
Posted: Mon 16 Sep 2013 12:24
by AlexP
Hello,
DetectOCI is an internal method not designed for calling from an application. Thereafter, access to this method will be closed.
Re: Direct mode and oci mode in parallel -> alternated connection closing
Posted: Tue 17 Sep 2013 15:38
by 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.
Re: Direct mode and oci mode in parallel -> alternated connection closing
Posted: Thu 19 Sep 2013 09:21
by 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