Re: connection lost while complex function is working

From: AleX <ashteren_at_netwiz.net>
Date: Wed, 30 Jun 1999 09:34:25 -0700
Message-ID: <377A4711.D04D5229@netwiz.net>

ruenagel_at_my-deja.com wrote:

> 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.

The best way to go about it would be to make sure that sqlnet.expire_time parameter is set to 0 on the server (in sqlnet.ora) Do you also get any ora-600's in your alert.log? Received on Wed Jun 30 1999 - 11:34:25 CDT