Re: connection lost while complex function is working

Normally there are two reasons which will cause the newwork disconnected. One, you session has exhausted the resources. For example, if you have a recursion function which will open cursor again and again. Then when it come to the limitation, the session will be killed. The other reason is if you function has to do a long long long time job and no response to client. listerner will think it is a dead connection and stop it. This will not happen normally unless you have changed the configuration of the listener since the default value is enough. Anyway it will not hurt to check this parameter.

Good Luck

Frank Rünagel wrote in message <37793044.0_at_news.arkaden.net>...
>Hi!
>
>My clients use Forms ad Report and
>are connected via telphone-line and tcp-ip
>to the server.
>
>If there are complex functions called, sometimes the network-connection
>is lost. Is there a solution that (big and slow) stored procedures
>or functions called by reports/forms
>send back to the client some kind of "Hold the line" message?
>
>Perhaps somebody has some advice for that problem? Thank you.
>
>Frank Ruenagel
>
>'A practical man is a man wo practices the errors of his forefathers.'
>Whitehead
>
>
Received on Tue Jun 29 1999 - 19:58:45 CDT