Re: Multi-threaded OCI application

I am using separate everything to do this, with all of the sessions logged in under the same userid/password.

There is an OCI function you have to call to make OCI threadsafe.

Rog

rakesh wrote in message ...
>If one is writing a OCI application that has multiple threads,
>each thread accessing rows of multiple tables from a single database,
>which of the following is the best approach ?
>Note that there is only userid.
>
>1. Have separate environment handles and separate user sessions for each
>sesssion.
>
>2. Every thread shares the same user session. In this approach, does the
>application
>need to ensure that all SQL statements are serialized ?
>
>3. Any other approach ?
>
>thanks
>rakesh
>
>
>
>
>
>
Received on Thu May 28 1998 - 22:22:52 CEST