Re: Newbie question ProC

"Volker Hetzer" <volker.hetzer_at_ieee.org> a écrit dans le message de [Quoted] news:c8fn4t$bg6$1_at_nntp.fujitsu-siemens.com...
>
> "Michel Cadot" <micadot{at}altern{dot}org> schrieb im Newsbeitrag
[Quoted] news:40a9236c$0$30600$626a14ce_at_news.free.fr...
> >
> > "Volker Hetzer" <volker.hetzer_at_ieee.org> a écrit dans le message de
> > news:c8b5e4$6ao$1_at_nntp.fujitsu-siemens.com...
> > >
> > > "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
> > >
> >
> > I'm not agree with you. These statements really disconnect from Oracle
> > as far as we can trust v$session as the sessions executing that disappear
> > from this view.
> Now wait. How do I commit without disconnecting?
>
> Greetings!
> Volker
>

EXEC SQL COMMIT WORK; [Quoted] without release.

Regards
Michel Cadot Received on Wed May 19 2004 - 15:35:34 CEST