Re: Newbie question ProC
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 17 May 2004 17:51:06 +0200
Message-ID: <40a8df49$0$24917$626a14ce_at_news.free.fr>
Date: Mon, 17 May 2004 17:51:06 +0200
Message-ID: <40a8df49$0$24917$626a14ce_at_news.free.fr>
[Quoted] [Quoted] "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;
Regards
Michel Cadot
Received on Mon May 17 2004 - 17:51:06 CEST