Devart Forums

Hello,

I have an application that is pooling a table in oracle from delphi (odac) every second. After a time, in some cases 20 minutes in other 50 minutes, the procedure can't be executed due to the connection lose and this app should be running 24/7. To solve this situation every 10 minutes I disconnect from the ddbb and connect again. My questions are:

Is this something related to the session time in oracle or the ODAC component?
Which would be "the best way" to "keep alive" the connection?

Thanks in advance.

PD: I have seen many answers related to the orasession, reconections etc, but ...