Oracle client-server connection lost!
Posted on 1999-07-27
I am running a applicaiton in client side. It basically
connects to DB one time and exec some sqls in a time
interval. If for some reason, connection beteen client and
server is lost, will there be any error? how to catch that
when the connection is lost, the client application is
just waiting (hanging..no errors reported). Will this be
waiting till the tcp/ip time out? can we catch the
connection lost error immediately? I want the client
application to cate the connection lost error and do some
action based on it.
I am using Oracle8i in Unix platform.