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,