1999 Erotic Nightmare

A guy who goes to a sorcerer who promises to give him erotic dreams, but the dreams come with a price that's more than money.