The Andy Griffith Show - Season 6 Episode 15 -

Warren is truly shy around women except when he is sleep walking. When he sleepwalks he turns into a Lothario of the first order--and his new conquest-to-be is Helen!