Do you remember an 80's movies where the boy was getting girl/sex advice from a dead but gorgeous woman?

The lady seemed to be like a great movie star that had passed away and
she was trying to help this young kid get laid. There was a geeky girl
that liked him but he wanted the hot motorcycle chic. In one scene he
even put a sausage in his pants.