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>


[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

Original text of this message