Session Lock in Multithreaded Programs

[Jens Fudickar]

Hello Marco,
is there any possibility to implement a check to see, that a query is running on an OracleSession from an other thread.

I think funktions like
function lock_session : boolean;
function is_session_locked : boolean;
procedure unlock_session;

Starting a query should lock the session automatic.

Is something like that implemented?

Jens

------------------

 

[Marco Kalter]

This is more or less what is happening behind the scenes if you set TOracleSession.ThreadSafe to True. However, these functions are private to the session and can therefore not be accessed from an application. You need to maintain your own administration in each thread so that you can see if a query is running.

------------------
Marco Kalter
Allround Automations

 

[Jens Fudickar]

Ok, but isn't it possible that you enhance the tOracleSession and export such a funktion to check for running queries.

That shoudn't be so difficult, or ?

Jens

------------------