Re: Newbie question ProC
Date: Mon, 17 May 2004 21:56:52 +0200
Message-ID: <c8b5e4$6ao$1_at_nntp.fujitsu-siemens.com>
[Quoted] "Michel Cadot" <micadot{at}altern{dot}org> schrieb im Newsbeitrag news:40a8df49$0$24917$626a14ce_at_news.free.fr...
>
> "Robert Trawinski" <robert.trawinski_at_softax.com.pl> a écrit dans le message de
> news:c8adg1$ptu$1_at_bozon2.softax.pl...
> > How can I disconnect from ProcC? SQL EXECUTE DISCONNECT does not work.
> > The real problem is that application talk to Oracle via firewall. After
> > few minutes of silence
> > I have to reconnect database. Maybe there's more elegant solution.
> >
> > Thanks for help in advance
> >
> > Robert
> >
>
> EXEC SQL COMMIT WORK RELEASE;
> or
> EXEC SQL ROLLBACK WORK RELEASE;
And even that is not a "disconnect". AFAIK, with proc you simply
exit your app and leave the database to work out the rest.
Not a bad strategy IMHO as the database has to deal with a creashed client
anyway.
Lots of Greetings!
Volker
Received on Mon May 17 2004 - 21:56:52 CEST