15 of 38
procedure data_change_test2 is
v_nr number;
pragma
autonomous_transaction;
begin
select count(1) into
v_nr
from
audit_emp;
dbms_output.put_line
(‘Count#3=‘||v_nr);
commit;
end;
procedure data_change_test1 is
v_nr
number;
begin
select count(1) into v_nr
from audit_emp;
dbms_output.put_line
(‘Count#2=‘||v_nr);
end;
uDeclare
v_nr number;
Begin
Select count(1)
into v_nr
u from audit_emp;
u
insert into audit_emp
values (user, sysdate, ‘Test’);
values (user, sysdate, ‘Test’);
u
dbms_output.put_line (‘Count#1=‘||v_nr);
u
u data_change_test1;
data_change_test2;
End;
(‘Count#2=‘||v_nr);
(‘Count#3=‘||v_nr);
(‘Count#1=‘||v_nr);
Autonomous
vs. Nested (3)
Parent Data Changes
Parent Data Changes
1
2
