What is the movie called where steve martin is a priest and he is trying to get a demon spirit.cont below.?

out of a little girl and towards the end of the movie hes in a room and all of a sudden he turns into a singer and starts singing lady with a blue dress on?