Hey Jml, sorry you've had this happen you, not nice.
I don't cath every night because it doesn't work for the bladder issue I have (my brain thinks it needs to go, but there is no urine there) but using a cath is really not a big deal - I thought it was - it sounds, well, it sounds bad. My MS nurse showed me how to use it, bit embarrasing, but it was ok, she's seen all sorts! But the reality is that if you are using 'Intermittant self-catheterisation' ISC for short, you just put the tube in (no discomfort and very quick) and take it out again, so you don't wear a bag overnight or anything. No one need know you're using ISC, the tube is in an applicator and you just click it open, use the ISC cath, it goes into the loo, and 3 mins later you're done.
Hope the symptom doesn't come back - and it is linked to MS leg problems, it hints at your lesions being in the spinal cord. This is where mine are too (as well as the brain