I had one in when I was tested for bladder reflux when I was seven. It had ink in it--I was lying down, and was supposed to pee, but I couldn't. They eventually gave up and had me pee in a toilet.
I don't remember it hurting, but it was obviously a very stressful event.
_________________
Living with one neurodevelopmental disability which has earned me a few diagnosis'