before delete trigger

 I have a table and the rows in the table sometimes gets deleted. I am planning to create an audit table and a before delete trigger. So whenever the rows in the original table gets deleted, it will insert a row to the audit table. This way the developer knows which row to delete in his copy table.

I have created the audit table using create table ticcrm.ttdsls921100_audit as select * from triton.ttdsls921100;

I have the following trigger:

create or replace trigger triton.before_delete_dsls921100

before delete on triton.ttdsls921100

for each row

declare

v_reflag := 'D'