How can I disable or enable a trigger withint the same tigger.
thank you
Printable View
How can I disable or enable a trigger withint the same tigger.
thank you
This is a new one to me. A trigger within a trigger ?
Or are you asking how to put a statement
'DISABLE TRIGGER' into the code of the trigger itself ?
Yes I am trying to disable an 'update trigger' which was create for the for each row on table 'A' in order to be able to update other rows on table 'A' and then enable the trigger again.
Because as it is I get
ORA-04091: table name is mutating, trigger/function may not see it