Re: Thread Safe DB access

From: Eric Mortensen <mortense_at_cibadiag.com>
Date: 1997/05/27
Message-ID: <338ACE60.701D@cibadiag.com>#1/1

B Krishna Swamy wrote:
>
> Hi,
>
> I need to know whether Oracle SQL-ProC libs are thread safe. I have a process
> which opens a connection with DB. When ever I get a request for accessing DB,
> I plan to spawn a thread and access (only read) DB using the connection. Can
> multiple threads concurrently use the same connection? Since performance is
> the major concern for me, I dont want to have any locks. Can SQL-ProC lib
> be used in this fashion?
>

In our Sun Solaris version of Oracle 7.3 we can write thread Embeded Pro*C. Oracle implemented Thread safty via context variables which you declare, allocate, and use in Oracle Statements.

Eric Mortensen
mortense_at_chirondiag.com Received on Tue May 27 1997 - 00:00:00 CDT