set autocommit off;

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; Received on Wed Aug 02 2006 - 11:59:00 CDT