ORA-03114: not connected to Oracle

[Pete S]

I receive the oracle error after PL/SQL Devloper is idle for more than 30 minutes. I have checked off the Ignore unrecognized PL/SQL box in the Program Window, but that does not help. Is there any way for this error not to appear?

Thanks,
Pete S

 

[Marco Kalter]

Does your Oracle user have a profile with a maximum idle time? If so, you can perhaps prevent the problem by enabling the "Check Connection" preference (Tools > Preferences > Oracle/Connection page). Now PL/SQL Developer will check every minute if the connection is okay, thereby preventing too much idle time for the session.

 

[Pete S]

Marco,
Thank you very much, that fixed the problem.

Thanks,
Pete S

 

[Marco Kalter]

Okay, thanks for letting me know.