A prostate exam might be uncomfortable, but it is not known to be painful, and there should not be lasting discomfort following the exam.
You might experience the urge to urinate or brief discomfort.