6 of 38
procedure p_log_audit (
who varchar2,
what varchar2,
descr_tx varchar2,
when_dt date)
is
Pragma
autonomous_transaction;
Begin
commit;
...
end;
insert into Audit_emp
values(audit_seq.nextval,
what,descr_tx,who,when_dt);
Simple
example of autonomous transaction
utrigger Bu_emp
before update
of sal on Emp
for each row
begin
p_log_audit
u (user,
u 'update',
'update of emp.salary', sysdate);
end;
1
2
3
4
