Re: Multi-threaded Pro*C clients?

From: Ronald <spamm_somewhere_else_ronr_at_worldaccess.nl>
Date: 1997/04/06
Message-ID: <spamm_somewhere_else_ronr-0604972130450001@news.worldaccess.nl>#1/1

In article <3344C404.46774780_at_uswest.com>, "Lance S. Nehring" <lnehrin_at_uswest.com> wrote:

> Is it possible for a multi-thread client to _simultaneaously_ access an
> Oracle database using concurrent connections???
>
> I'm using Oracle7.23 on a HP 9000/829 running HPUX 10.10 (The threads
> package is POSIX draft IV).
>
> Testing so far indicates that concurrent connections are okay and using
> threads is okay.....but, thou shalt not access the database
> simultaneously in two different threads (even with separate
> connections). I've also tried making the SQLCA private to the functions
> that require it without any affect (positive or negative).
>
> The error is typically an ORA-01002 Fetch out of sequence.
>
> I'm guessing that Oracle client code is simply not reentrant so what
> I've tried just cannot work. Could this be something Pro*C cannot
> handle but OCI could do???
>
> Has anyone else tried this?? Is there a version of Oracle that can do
> this??
>
> Thanks,
> Lance

As far as I know, the oci libs are thread-safe as of version 7.3.

Ronald

mailto:ronr_at_worldaccess.nl
http://www.worldaccess.nl/~ronr (last update march 15. 1997) Received on Sun Apr 06 1997 - 00:00:00 CST