I've had sex in both lucid and non-lucid dreams and experienced orgasm in both. Unfortunately, in both types of dreams, orgasm usually results in my waking up (i.e., I come.. the dream goes).