OCI: Multiple Transactions on a Connection

I am trying to [re]write a server using OCI. The server uses one username/password for all clients. I can set up on service context and support multiple SELECT queries from various clients.

I may have to support mutiple simultaneous transactions It looks like one service context == one transaction.

The OCISessionBegin will not allow multiple service contexts to be attached to a single session.

It there are way to have mutiple service contexts (=> multiple transaction) with one session?

If not what approach should be taken? Multiple connections?

Thanks, Received on Thu Nov 09 2006 - 11:05:29 CST