When
cactus collapse, it's usually a sign that the plant is rotted. This happens from being overwatered, even slightly, over a long period of time. One time I had a large
cactus near the front door, where there was not a lot of light. I always checked the top of the soil, and watered it just a little every couple of weeks. It looked great for a couple of years. Then one morning it was collapsed, like a balloon that had been partially emptied of air. And, like yours, there was juice dripping out where it was kind of folded.
I have since learned, the secret to watering
cactus indoors is to check the soil all the way to the bottom of the pot. Use a long wooden dowel, or a shish kebob skewer, and stick it into the soil as if testing a cake. For
cactus, you shouldn't water until the skewer feels completely dry between your fingers, and has no dirt sticking to it. For more info, you might visit
http://www.youtube.com/watch?v=W9fkseDb1YsIn general, when you water any plant, you should water until you get a runoff. However, if the
cactus doesn't have enough light to use all the moisture in the soil within 4 weeks, don't put that much water into it. It shouldn't stay damp, even slightly damp, for more than 4 weeks at a time.
Unfortunately for your plant, collapsed and rotted means dead. Don't be afraid to try again, and remember to check the soil, always, before you water.