OnConnectionLost - Reconnects but the next action raise OCI_INVALID_HANDLE

[JoaoMarcos]

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,

[MaximG]

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.