last year i mentioned that there are problems with
oracle 11 client and doa.
since nobody could give me an idea what to do i kept
using oracle 11 client.

today i found a curious workaround...

my environment:
1 main process with 3x toraclesession
2-10 threads each with toraclesession and one query

problem: when ever the session in the threads started
i got an external exception and all oracle session even
in the main process crashed

workaround: i set the THREADSAFE property in all oraclesessions to TRUE and everything works fine.

question: i wonder if this brings my thread model back to
serial execution of all the oracle actions.
i wanted to use threads because i needed a non blocking
way to access oracle from different event controlled threads

and why does this not happen in oracle 10 client ?

help is absolutley appreciated !

cheers
claus reinhardt

[quote]question: i wonder if this brings my thread model back to serial execution of all the oracle actions.[/quote]
Only database activities for the same session will be serialized. If multiple threads access the same TOracleSession instances, then ThreadSafe must be set to True.