Re: locks

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 10 Aug 2006 22:39:26 +0100
Message-ID: <hl9nd2d686f21bbs154pvcblmcujhocejg@4ax.com>

On Thu, 10 Aug 2006 20:59:16 GMT, HansF <Fuzzy.Greybeard_at_gmail.com> wrote:

>On Thu, 10 Aug 2006 19:37:09 +0200, Sybrand Bakker wrote:
>
>> exiting *normally* will end the database connection and will issue a
>> commit.
>
>I always thought 'exiting *normally* without explicitly issuing a commit'
>will issue a rollback, and the 'commit on exit' syndrome was a 'feature'
>of the calling environment (such as SQLPlus).

The OCI function OCISessionEnd has always committed the current transaction. No idea about the v7 and earlier equivalent - ologoff or something wasn't it?

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Thu Aug 10 2006 - 16:39:26 CDT