Can you tell if client/server connection is OK? (OCI)
From: Brad Lotsberg <lotsberg_at_willowglen.ab.ca>
Date: Mon, 17 Apr 2000 22:39:08 GMT
Message-ID: <38FB92D3.2922C708_at_willowglen.ab.ca>
I am writing an OCI program and would like to be able to tell easily if the client - server network connection is OK. If it isn't , I suppose the return code from the OCI call will indicate an error, but it would be nice if I could "test" the connection at the beginning of a function and decide whether or not I should attempt to re-connect, or alternately if an OCI call fails, check the connection to determine if that might have been the cause of the failure. The ideal solution for me would be a simple OCI call that returns the server connection status, but I can't find such a call. Any ideas are appreciated.
Date: Mon, 17 Apr 2000 22:39:08 GMT
Message-ID: <38FB92D3.2922C708_at_willowglen.ab.ca>
I am writing an OCI program and would like to be able to tell easily if the client - server network connection is OK. If it isn't , I suppose the return code from the OCI call will indicate an error, but it would be nice if I could "test" the connection at the beginning of a function and decide whether or not I should attempt to re-connect, or alternately if an OCI call fails, check the connection to determine if that might have been the cause of the failure. The ideal solution for me would be a simple OCI call that returns the server connection status, but I can't find such a call. Any ideas are appreciated.
Thanks in advance,
Brad Lotsberg, EET.
lotsberg_at_willowglen.ab.ca
Received on Tue Apr 18 2000 - 00:39:08 CEST