Re: How to close session?
From: Bob Bain <bob.bain_at_terra-nova.e-mail.com>
Date: Thu, 16 Dec 1999 10:00:47 -0000
Message-ID: <nM264.7$654.307_at_news.colt.net>
Date: Thu, 16 Dec 1999 10:00:47 -0000
Message-ID: <nM264.7$654.307_at_news.colt.net>
The only way I know of doing this is to issue a
EXEC SQL COMMIT WORK RELEASE; This will commit all change made in your program and log you off ORACLE, of course you could always use ROLLBACK WORK RELEASE as well.
wls <cuba_at_ms.chttl.com.tw> wrote in message
news:945138648.830515_at_news.chttl.com.tw...
>
> Does anybody know how to close a session before a C program exit?
> I am using the OLE DB to connect with the ORACLE server....
> I check the v$session and find that there are many INACTIVE session
exist.
> Please tell me how to avoid the problem? thank you :)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Received on Thu Dec 16 1999 - 11:00:47 CET