OraAlerter and disconnection

[Daniele Buttarelli]

Hi,
I have a problem with TOraAlerter (EventType = etAlert).
When the OraSession disconnect unexpeced I get the ORA-01113 error.
I'm trying to use the LocalFailover to restore the connection (LocalFailover := True and RetryMode := rmReconnectExecute) but I keep getting the ORA-01113 error.
Without activating the alerter It works well.

Here is the bugreport:

exception number : 1
exception class : EOraError
exception message : ORA-03113: end-of-file on communication channel.

main thread ($1ef4):
009e6192 +1ce TeseoSrvEngine.exe OraClasses TOCIConnection.OraError
009f1b5d +03d TeseoSrvEngine.exe OraClasses TOCICommand.Check
009f4537 +23b TeseoSrvEngine.exe OraClasses TOCICommand.InternalExecute
009f4973 +1cf TeseoSrvEngine.exe OraClasses TOCICommand.Exec
009fa3ed +045 TeseoSrvEngine.exe OraClasses TOCICommand.DoExecute
009fa52d +0e5 TeseoSrvEngine.exe OraClasses TOCICommand.Execute
00a152c2 +176 TeseoSrvEngine.exe OraClasses TOCIAlerter.SendAlertMessage
00a13a2c +034 TeseoSrvEngine.exe OraClasses TOCIAlerter.SendEvent
00a15825 +051 TeseoSrvEngine.exe OraClasses TOCIAlerterListenThread.Terminate
00a1417e +032 TeseoSrvEngine.exe OraClasses TOCIAlerter.Stop
009eaddf +24f TeseoSrvEngine.exe OraClasses WndProc
76627885 +00a USER32.dll DispatchMessageW
0072fe5f +0f3 TeseoSrvEngine.exe Vcl.Forms TApplication.ProcessMessage
0072fea2 +00a TeseoSrvEngine.exe Vcl.Forms TApplication.HandleMessage
007301d5 +0c9 TeseoSrvEngine.exe Vcl.Forms TApplication.Run
01398ac8 +07c TeseoSrvEngine.exe TeseoSrvEngine 47 +15 initialization
75ae3368 +010 kernel32.dll BaseThreadInitThunk

Delphi XE7/ODAC 9.4.14

How can I solve this problem?
Thanks for your help.

[AlexP]

Hello,

We cannot reproduce the problem on the latest ODAC version. Try to reproduce the problem on the latest ODAC trial version: http://www.devart.com/odac/download.html , and let us know the results.

[Daniele Buttarelli]

I solved the problem using OraSession.OnError (Fail := False);
Thanks.

[AlexP]

Glad to see that you solved the problem. If you have any other questions, feel free to contact us.