End of Days
(2008)

The devil (Gabriel Byrne) ultimately possesses Jericho (Ah-nold) in a final atempt to impregnate Christine (Robin Tunney).
Jericho fights it and impales himself, thus saving Earth from the Anti-Christ.
  

Thanks Herbert!