11 of 38
Autonomous
vs. Nested (1) Example
Locks
declare
v varchar2(2000);
ubegin
u select
ename
into v
from emp
u where ename =
SCOTT'
u for
update;
lock_test;
u
u commit;
End;
procedure lock_test
is
v varchar2(2000);
pragma autonomous_transaction;
begin
select
ename into v
from
emp
where ename =
'SCOTT'
for update;
commit;
end;
1
procedure lock_test is
v
varchar2(2000);
begin
select ename into v
from emp
where ename = 'SCOTT'
for update;
end;
2
