At least nine soldiers have been killed in an attack on a military base in southern Yemen, military officials say.