Hi,

This is how archiving of deleted data works around here.

CREATE OR REPLACE TRIGGER del_trg
after delete on prod.tbl
referencing old as old
for each row
declare
sqlerr number;
begin
insert into arc.tbl (
col1,
col2,
del_dt)
values (
ld.col1,
ld.col2,
sysdate);
end;
/

HTH

Tycho