For example, when the database goes down or my connection or link to the database server goes down while an application is running, how can I handle that gracefully or how will I know that the database is down or I'm no longer connected to oracle so that I could prompt something for the user for them to know that a problem occured on the application(currently the application just hangs when oracle is down)?
I would likely appreciate any suggestions that would come from you guys!
Thank you very much!
This is an interesting question. In one of my projects, i handle this issue using a timer object (VB) that is periodically generating a short SQL statement. If execution fails (Error handling with 'on error goto ...'), the user is getting informed that the application now is in offline state. While the application is 'offline', the mentioned timer tries periodically to reconnect to the db. Every Oracle statement is protected by a error handling, so a unwanted runtime error can't occur. I'm not sure if this is really the best way to handle this, but it works for us.