It depends on how intoxicated you are, I suppose. If you are really "gone", I suspect it would be possible to not feel it. I expect it would leave a mark on the skin, though.
If it is a small syringe with a sub-cu needle such as diabetics use you probably wouldn't even feel it if you weren't on cocaine. It won't leave a mark on the skin.