13 of 38
uBegin
u dbms_output.put_line
(‘Start value: ’||
 var_test.global_nr );
u
• var_test.global_nr := 10
u
u p_var_test (20);
u
u dbms_output.put_line
(‘After auto value: ’||
 var_test.global_nr );
u
uEnd;
procedure p_var_test 
(v_nr number) is
   pragma autonomous_transaction;
Begin
dbms_output.put_line(
‘ Before Auto value: ‘|| var_test.global_nr );
   var_test.global_tx := v_nr;
commit;
end;
package var_test
As
global_nr number :=0;
end;
dbms_output.put_line
(‘Start value: ’||
 var_test.global_nr );
var_test.global_nr := 10
dbms_output.put_line(
‘ Before Auto value: ‘|| var_test.global_nr );
var_test.global_tx := v_nr;
dbms_output.put_line
(‘After auto value: ’||
 var_test.global_nr );
Autonomous vs. Nested (2)
Example - Variables
0
10
20
0
10
20