Is the sexual act contrary to achieving enlightenment?

I remember reading in a sutta that the Buddha said not engaging in the sexual act is considered right action. Does anybody know the place where that is written? I don’t remember where I read it.