After delete trigger
create or replace trigger TRITON.AFTER_INSERT_DELETE_tdsls040100
after insert or delete on TRITON.TTDSLS040100
for each row
begin
if INSERTING then
insert into event.tdsls040_change_tracking
(Primary_Key,
Column_Name,
Table_Name,
Original_Value)
values
(:new.T$ORNO,
'T$COMP',
'TTDSLS040100',
:new.T$COMP);
elsif DELETING then
delete from event.tdsls040_change_tracking
where Primary_Key =:old.T$ORNO;