Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: connection lost while complex function is working
In article <377956D5.FA462CB9_at_netwiz.net>,
AleX <ashteren_at_netwiz.net> wrote:
> "Frank Rünagel" wrote:
>
> > 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
>
> Can you be more specific? Is there a networking
(meaning the o/s level)
> connection lost or is there a sqlnet connection
loss? Which Oracle rdbms
> are you on? what's the client version?
>
It's oracle 7.3 and there is a networking o/s level connection lost: the router simply has a timeout and hangs up. We do not want to increase the timeout. So the called function or the listener/server (?) should periodically send some kind of TNSPING to the client. Is it possible?
Frank Ruenagel via dejanews
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Jun 30 1999 - 10:39:17 CDT
![]() |
![]() |