Re: set autocommit off;

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Wed, 02 Aug 2006 21:59:45 GMT
Message-Id: <pan.2006.08.02.22.02.10.305435@gmail.com>

On Wed, 02 Aug 2006 13:42:44 -0400, Mark C. Stock wrote:

>
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1154538696.856949_at_bubbleator.drizzle.com...

>> [quoted text muted]

>
>
> for the OP's question, this seems to hit the nail on the head
>
> however, IIRC, the OCI interface can manipulate an autocommit setting...
> it's been a while, so i don't remember the details.
>

From the OCI doc ...

 Using the OCI_COMMIT_ON_SUCCESS mode of the OCIExecute() call, the  application can selectively commit transactions at the end of each  statement execution, saving an extra round trip.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Wed Aug 02 2006 - 16:59:45 CDT