posted 20 years ago
Hi,
I'm facing a problem in writing row level trigger for each row after insert.
My requirement is whenever the salary is inserted in emp table , i want to update the commission column as well and this has to happen for each row that gets inserted. But as the trigger is i'm trying to update the same table in question
i.e. mutating table...i get error
ORA-04091: ... is mutating, trigger/function may not see it ORA-06512....
Do you have any work around for this sort of requirements?
Thanks in advance.
regs
DEZ