Tomorrow I'm going to doctor so they cant stuff and camera in my :(?

i went to the doctors a month ago and he said that i got a small amount of blood in my pee, but i cant see it they look under microscope or something, and tomorrow there going to stick a camera up there to view inside to see why, and I'm scared, they said there not going to put me to sleep while doing it my eyes and brain is going to be working, but are they going to numb it and how and will it hurt?