I had it in the ball of my foot when they first thought I had gout.
It went numb and then the other foot also. So I don't think the shot actually worked, I think it was the process of pain then going numb.

But with your shoulder I'm not sure. I have constant pain in the groin and leg so I know what you are saying.
Sorry not much help.
Phil