How to reconnect to Oracle when the server goes down !

Hello :

I am wondering if anybody has solution to this problem :

We have a real-time application that has to send updates to be inserted to database running on a remote server. By the way, the databases we have can be ORACLE or SYBASE.

Now the problem that we are facing is :

Suppose the database server goes down on its own. It could be shutdown or any crash that can cause it to happen.

Now if our application wants to insert anything to database, we get a error message saying that we are not connected to the database

Now if we try to reconnect to database again (Suppose the database is brought back again) , our application still gets error saying that we are still not connected to database and assumes that we are already logged-in as if it stores its past history

Can anybody suggest what should we do in our application.

We are using Oracle 7.0 on Sun

Any pointers to reference are also welcome.

Parag Rastogi
1-718-273-8234

-- 
The nice thing about standards is that there are so many of them to
choose from.
		-- Andrew S. Tanenbaum


-----------------------------------------------------------------------

#include <std_disclaimers.h>
From:prastogi_at_netcom.com


-----------------------------------------------------------------------