Oracle sessions and delphi threads

[amoroder]

Hello,

I am writing a windows service that should do different jobs in threads. All the threads have to connect to the same oracle database and schema.
Is it possible to work with only one session or do I have to create a session for every thread ?

Thanks
Andreas

[AlexP]

Hello,

Full thread-safety is really guaranteed in the OCI mode, we recommend to use a separate connection for each thread in the Direct mode

[jfudickar]

What does it mean : full thread safety?
My experience show that it's not possible to have to sql statements executed at the same time.

Regards
Jens

[AlexP]

You can find samples of work with threads in ODAC in the demos: ..\Devart\ODAC for RAD Studio XE\Demos\OdacDemo\Threads\