Compulsive hoarding
Obsessive-compulsive disorders are treated with various serotonergic antidepressants including the tricyclic antidepressant clomipramine and various SSRI medications. With existing drug therapy, OCD symptoms can be controlled, but not cured. Several of these compounds (including paroxetine, which has an FDA indication) have been tested successfully in conjunction with OCD hoarding.
Sexual obsessions
Medications specifically for OCD (typically SSRI medications) will help alleviate the anxiety but will also cause some sexual dysfunction in about a third of patients. For many the relief from the anxiety is enough to overcome the sexual problems caused by the medication. For others, the medication itself makes sex truly impossible. This may be a temporary problem, but if it persists a competent psychiatrist can often adjust the medications to overcome this side-effect.