Re: Newbie question ProC

Michel Cadot wrote:
> "Volker Hetzer" <volker.hetzer_at_ieee.org> a écrit dans le message de
> news:c8fn4t$bg6$1_at_nntp.fujitsu-siemens.com...
>

>>"Michel Cadot" <micadot{at}altern{dot}org> schrieb im Newsbeitrag

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

Sorry that I'm late but I was out of my office for a few day. Thanks for help.

Robert Received on Fri May 21 2004 - 16:07:23 CEST