Comets whose orbits in the Oort Cloud have been "stretched" into long ellipses by the gravitational pull of nearby stars,  so that  their perihelion is quite near the sun. A period for such a comet may be as much as tens on thousands of years.