Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connection lost while complex function is working

Re: connection lost while complex function is working

From: <ruenagel_at_my-deja.com>
Date: Wed, 30 Jun 1999 15:39:17 GMT
Message-ID: <7lddn3$hh2$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US