Ora-3113 end-of-file on communication channel

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kurtbilde
Posts: 114
Joined: Wed 16 Mar 2005 16:02
Location: Odense, Denmark

Ora-3113 end-of-file on communication channel

Post by kurtbilde » Fri 11 May 2012 17:23

Hi,

I have set the ConnecttionLost event to:

RetryMode := rmReconnectExecute;

, but I still got the Ora-3113... Is there another apoach to prevent Ora-3113?

-Kurt

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Ora-3113 end-of-file on communication channel

Post by AlexP » Mon 14 May 2012 09:43

Hello,

To activate the onConnecttionLost event, you also should enable the LocalFailover option. In this case, when connection is lost, an attempt to reconnect will occur. This error will occur when running the program from the IDE even when there is the onConnecttionLost handler (if the Stop On Delphi Exceptions option is disabled). When running the *.exe file, there will be no error.

Post Reply