Re: set autocommit off;

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 2 Aug 2006 13:42:44 -0400
Message-ID: <35idnXNSDLWKeU3ZnZ2dnUVZ_u-dnZ2d@comcast.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1154538696.856949_at_bubbleator.drizzle.com...
: mike7411_at_gmail.com wrote:
: > Anyone know why Oracle won't let me do this
: >
: > set autocommit off;
: >
: > in a PL/SQL procedure?
: >
: > It won't take this:
: >
: > create or replace procedure addname
: > as
: > begin
: > set autocommit off;
: > insert into test values('testname');
: > commit;
: > end;
:
: Autocommit has nothing to do with the database. The database never
: commits.
:
: Applications commit.
:
: SET AUTOCOMMIT OFF is an instruction to SQL*Plus ... not the database.
: --
: Daniel A. Morgan
: University of Washington
: damorgan_at_x.washington.edu
: (replace x with u to respond)
: Puget Sound Oracle Users Group
: www.psoug.org

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.

++ mcs Received on Wed Aug 02 2006 - 12:42:44 CDT