Re: OCI cursors and fork().

From: Konstantin Kivi <konst_at_sirena.rinet.ru>
Date: Thu, 19 Nov 1998 19:04:19 GMT
Message-ID: <F2onn7.5Iz.0.debian@sirena.rinet.ru>

geraintwilliams_at_my-dejanews.com wrote:
> Can you help?

> I am trying to write a small server program (c with OCI calls),
> which logs into the database and forks a process to execute a piece of SQL
> for each request it receives.

> However, I am unable to open and use cursors from separate processes
> concurrently. Is there a way around this, or will I have to open a
> new connection to Oracle each time I fork?

> I am using oracle 7.3.4

> Many thanks to anyone who can help me.

> Geraint

It is not possible. If you realy want to have several proceses the each must make its own connection.

--
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru

aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org Received on Thu Nov 19 1998 - 13:04:19 CST