A stimulation lead is disclosed. This lead comprises a lead body having a lumen housing an inner conductor, the conductor being axially and rotationally movable within the lumen, and coupled to a generator of an active implantable medical device. The lead also has a helical anchoring screw extending from a distal end configured to penetrate target tissue, and a stimulation needle electrically coupled to the conductor and comprising at its distal end an active free portion with at least one stimulation electrode for application of pacing pulses to the target tissue. The stimulation needle is axially movable between a retracted position inside the tubular body, and a deployed position with the active free portion of the needle emerging out of the tubular body, utilizing an actuating mechanism for moving the needle from its retracted position to its deployed position under the effect of rotary movement relative to the lead body.