Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ProC and the UNIX fork!?!

Re: ProC and the UNIX fork!?!

From: Konstantin Kivi <konst_at_sirena.rinet.ru>
Date: Fri, 22 Jan 1999 15:38:12 GMT
Message-ID: <F5ywrp.9HA.0.debian@sirena.rinet.ru>


Alexandre Wagner Agostini <agostini_at_unisys.com.br> wrote:
> Hi, guys!

> I've made a system like this: client-server, the client side just
> get two parameters and then
> send it, via ordinary TCP/IP connection to the server which has a
> permanent connection
> with an Oracle db. The server was written using ProC. The problem is
> that when the whole
> thing runs I get ,after a while (a few minutes), the error "maximum
> number of open cursors
> exceeded" e then the connection with Oracle falls.
> I suspect this is due to the fact that I open the db connection once,
> then to each new
> TCP connection I fork off a child to handle the operation with the db.
Don't do so. You must open connection after fork.

--
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 Fri Jan 22 1999 - 09:38:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US