Devart Forums

Hi,

I have a TOraSession with Options.LocalFailover set to true and have a OnConnectionLost event just with the line:

RetryMode := rmReconnectExecute;

I made a text log and the event has been fired and the reconnection Works. But if the user tries to acess a record in an already open recordset the error OCI_INVALID_HANDLE will be raised.

The connection is in OCI mode. Oracle Client version is 9i.

Is there a way to reconnect and use the same connection (or session) as before the connect was lost?

I'm trying to avoid using DisconnectMode for now.

Thanks,

We have checked ODAC 9.7.27, using OnConnectionLost event and found no issues. For further investigation, please compose a small sample, demonstrating the issue and send it, using the contact form https://www.devart.com/company/contactform.html, including the script, creating the database objects in the sample.