Re: set autocommit off;

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