Timeout on logon

[Michiel Sijbers]

I use TOracleSession.Logon to log on to a database. When the database I'm connecting to is down, I do not get an exception but instead the Application is endlessly waiting.

Is there a way to define a timeout for a specific amount of time, after which the session returns an exception?

 

[Marco Kalter]

This is all handled at the Oracle Client/Server level. You should typically get an "Oracle not available" error though. Does the same behavior happen with (for example) SQL*Plus?