17 of 38
procedure commit_test
is
pragma autonomous_transaction;
begin
  insert into audit_emp
  values (user,sysdate,'Test',2);
commit;
end;
udeclare
u  v_nr number;
uBegin
u  set transaction isolation
level read committed;
u   
u  insert into audit_emp values (user,sysdate,'Test',1 );
u
u  commit_test;
u    
u  select max(log_id)
u  into v_nr
u  from audit_emp;
u
u  dbms_output.put_line
         (‘Maximum='||v_nr);
uend;
1
read committed;
2
Autonomous vs. Nested (4)
Child Data Changes
serializable;
max(log_id)