Unanswered: updating the same table in a update trigger
Is it possible? I have been able to solve the mutating table error with creating package tables. But it seems that my update query inside of the update trigger will call the trigger again, like recursively. Is there anyway for me to do disable trigger before the update, then enable it again after the update inside of the update trigger?
Currently I am getting
ORA-00036: maximum number of recursive sql levels num exceeded.