Home -> Usenet -> comp.databases.oracle -> Yoo Hoo--are you still there?

Yoo Hoo--are you still there?

From: Jean Anderson <jean_at_seismo.CSS.GOV>
Date: 11 Nov 92 20:28:23 GMT
Message-ID: <51455_at_seismo.CSS.GOV> 






What's the cheapest way to tell from OCI if a frontend database connection 
is still alive? I want to do something like this:


	if(db_dead()==TRUE)
	{
		-- do something reasonable, maybe re-establish connection
	}





I'm looking for a cheap ping for db_dead(), maybe a "select 'x' from dual",
although I'd like to avoid a select.



Is there a better way to check, maybe already a hook I don't know about?



thanks,



 -jean


+-----------------------------------------------------------------------+


| Jean Anderson, DBA                       email:  jean_at_esosun.css.gov  |


| SAIC Open Systems Division, MS A2-F                                   |

| 10210 Campus Point Drive                 phone:  (619)458-2727        |

| San Diego, CA  92121                       fax:  (619)458-4993        |

 +-----------------------------------------------------------------------+


|            execute disclaimer(opinion => 'mine');                     |


+-----------------------------------------------------------------------+


Received on Wed Nov 11 1992 - 21:28:23 CET












Original text of this message