Will a spermatic cord block affect fertility?

if he just gave a shot to deaden or numb the nerves it will not last and you will be able to ejaculate and have children when you re older