"Hysteroscopy"

Yesterday I went to my appointment at the City Hospital Nottingham for a routine Hysteroscopy due to abnormal bleeding whilst menopsausal. I did attend an appointment 2 weeks ago where a biopsy was attempted but it was too painful so yesterdays appointment was with a local anesthetic. The needle its self was very painful and as far as I am aware unsuccessful in numbing the area because when the Dr attempted to insert the camera I felt a lot of pain, So they abandoned the camera and proceeded to take a biopsy, advising I may feel a little discomfort. Discomfort was not the correct term, I was in agony and screamed out to stop, the dr advised that they was almost finished but if I wanted them to stop they would, The pain was excruciating and I asked them again to stop at which point I went dizzy and felt very nauseous, almost passing out completely. I felt ignored by the doctor. I went cold and very clammy and almost lost consciousness. I now have to return for the same procedure but under general anesthetic.