Hi Guys,

I am querying remote database via db link. In between the queries the remote db goes down and up. Next time I do my query established db link fails. Though when I repeat the query second time and it works. Obviously db link was rectified (re- init) after first failure. The Question is :
Is there a clean way to identify if the dblink is broken and re-init it before issuing a query.

Thanks in advance