Like all drug abuse, using prescription drugs for the wrong reasons has serious risks for a person's health. Opioid abuse can lead to vomiting, mood changes, decrease in ability to think (cognitive function), and even decreased respiratory function, coma, or death.