26 of 38
Usage #1a:
Example
Create or replace view v_emp
As
Select empno,
ename,
audit$pkg.f_clean
(empno, sal) sal
ename,
audit$pkg.f_clean
(empno, sal) sal
From temp_emp
package body audit$pkg as
function f_clean
(i_id number, i_nr number)
(i_id number, i_nr number)
return
number
is
pragma
autonomous_transaction;
autonomous_transaction;
begin
delete from temp_emp
where empno = i_id;
commit;
return i_nr;
end;
End;
Select empno,
ename,
sal
From v_emp
Select
…
From
temp_emp
Delete
from
temp_emp