How to prevent automatic disconnection ?

From: <futurocom_at_wanadoo.fr>
Date: Thu, 01 Apr 1999 10:16:30 GMT
Message-ID: <370328e7.4601676@news.wanadoo.fr>

How to prevent automatic disconnection.

We are making a system composed of

Oracle RDBMS (ver 7.3.2) and server with Unix SCO
Clients running on windows NT Workstation 4.0 The different machines are linked together with TCP.IP protocol and SQL*Net Ver 2.0. Dialog between clients and server uses OCI commands. We have this problem :

If the client connected to the server doesn't work (no SQL request sent) for about 2 hours, the link with the data base is broken and so the client doesn't received information sent
by the server anymore.
How is it possible to prevent automatic disconnection ?

Thank you for your help. Received on Thu Apr 01 1999 - 04:16:30 CST