If you want the update to succeed even if the trigger fails, add an exception handler with WHEN OTHERS THEN NULL;