19 of 38
procedure rollback_test is
pragma autonomous_transaction;
begin
   insert into audit_emp values (user,sysdate,'Test',1);
insert into audit_emp
values (user, sysdate,
       'Test',0);
commit;
end;
Autonomous vs. Nested (5):
Exceptions
uDeclare
u     v_nr number;
uBegin
u rollback_test;
uException
uwhen others
uthen
u select count(1)
u into v_nr
u      from audit_emp;
u  
u   dbms_output.put_line
(‘Count=‘||v_nr);
u
uend;
procedure rollback_test is
begin
   insert into audit_emp values (user,sysdate,'Test',2);
insert into audit_emp
   values
(user, sysdate, 'Test', 0);
end;
1
2
insert into audit_emp
values (user, sysdate,
‘Test',’Wrong datatype’);
insert into audit_emp
values (user, sysdate,
‘Test',’Wrong datatype’);