Use semicolon before the OLD.column_name, like
....
VALUES (
:OLD.Benefit,
:OLD.SortOrder,
....)
And don't use COMMIT inside your trigger. COMMIT and ROLLBACK can't be used in the trigger, unless you use AUTONOMUS_TRANSACTION pagma.
|
Results 1 to 8 of 8
Thread: Archiving Deleted RecordsThreaded View
|
Click Here to Expand Forum to Full Width |