Rewrite : split table parm_periode into parm_periode and parm_exercice disabling temporarily a trigger is not the right solution , but make the trigger more flexible and less secure is worst. The trigger is disable in a transaction means it is still enable for other session.