Application does not recover from network failure

[jschmied]

Hi!

I have a Application which calls a plsql function which takes 10 sec. in a loop.

If the network connection is cut off for a few seconds in about 50% the application just hangs.

In the other 50% i get a ora-3113.

What can I do??? I need to handle the reconnect gracefully but i cant get the control back, the app just hangs infinately.

(ps: Ora 9.2 Delphi 7)

Thanks

juergen

 

[jschmied]

Using FlexTracer ( http://www.codexploit.com/flextracer).

I see that the call to OCIStmtExecute is not comming back ;-((

 

[Marco Kalter]

If OCIStmtExecute hangs indefinitely, then you have a problem regaining control in your application. As you probably know this function is located in the Oracle client library (oci.dll). The only solution within the application is to perform the call in a thread, to detect a hang-up, and to kill the thread. You will also lose the session and all components linked to the session. In other words, you would need to restart the application.