Trigger in order to prevent update
FilipFryJan 12 2011 — edited Jan 12 2011I want to create trigger that will prevent illegal updates, but for illegal data I want make insert in another table. In order to prevent update i have to raise exception but then it will rollback insert. I am aware of autonomous transactions(putting that insert i some procedure that is autonomous transactions) but it looks to me like dirty way of solving the problem. Is there any other way to prevent update that does not include raising exception. I am also against updating on same values. Thanks!