Reconnect after being timed out by database

jfitz

Member
Do anyone know any options or setting in PL/SQL developer for handling sessions. When I use the app from my PC, if my session times out and I try to disconnect and reconnect, I get error messages and cannot continue. I then have to close out the app and reopen. When connected via citrix, if a session times out I can simply disconnect, reconnect and continue working. We run 7.0.3.1123 locally and via citrix. Is there a setting that can be changed so my local version will allow me to just disconnect and reconnect when my database connection times out?
 
You could try the "Check connection" preference (Tools > Preferences > Oracle / Connection). When enabled, PL/SQL Developer will check once per minute if the connection is still alive, and if not, will disconnect. If Oracle Net cannot recover from such a failure, you will still need to restart PL/SQL Developer though.
 
Back
Top