Sorry to hear about this, mate.
Are/were you taking oxycontin or oxycodone? If it was slow release, it was most likely oxycontin.
It's horrible shit. I have had to take it before, and now I refuse to take it.
I have a patch that is just awesome. It lasts a week, and is absorbed via skin, where my body metabolises it into the painkiller.
It's great because you wake up without the sudden edge from not having pain meds.
I also have oxynorm (aka oxycodone) for breakthrough pain. I find I tend to average about 2 per day of them. They don't give me the horrible feeling that oxycontin does, but they only last 3-4 hours. Good for breakthrough pain, and probably a better choice for you at the moment.
I've never had to have a camera up my wang, but I did have to have a catheter up there last year, due to my whole body being septic. Long story, but it was extremely serious.
It's difficult to explain to people who've never had one, but geez, the feeling of it being put in is just.....it is weird, and it definitely doesn't feel 'right'. Then having them pump up the balloon inside you so it stays in. It's just the most bizarre feeling.
Hope you're on your feet again soon. My advice is distraction. If you're really hurting, do a favourite activity (that's also gentle), whether it's watching a favourite movie, reading a good book, whatever. Meditation is also great, but it does require some guidance if you're unfamiliar with it.