I've been getting very odd pains upper right abdo area for a few months, bit the bullet and saw GP who's sorted a scan on Sunday morning, . I'd been on Naproxen which is near guaranteed to screw up your guts so it may be an ulcer...or my Liver is like a rugby ball 
Having worked in Op theatres I'd be insisting on sedation for a scope, none of this spray malarkey
Had 2 endoscopes a few years back for an ulcer. Got there for the first one and they give you the option of the full "knock you out" general anestheic, or just a local spray. I opted for the local coz you have to stay in hospital for obs for at least 4 hours after a general, and they aren't keen on you driving the same day. I had to get home from Shepton Mallet to Yeovil.
Then I saw the endoscope - I was expecting a micro thin key hole fibre-optic thingy certainly no bigger than a mains cable. What they used was more like 10mm in diameter. It's a real struggle to avoid gagging on the damn thing and they seem to be sucking your stomach dry through it to avoid choking. Whilst in there they take 4 or 5 biopsies using a grabber thing which plucks lumps off the inside of your asophogus. Not pleasant at all. Still I was out in 20 minutes and knew what to expect on the second visit when the ulcer had gone.
I'm on Omeprosol, and the quack reckons half the population over 45 is too. Seems to do the trick, but best to take a double dose before any night out to the curry house.