1. To move into a new place of residence. The phrase refers to an outdated practice of hanging a pouch for small tools on the wall of one's home. A: "Has she stuck her spoon in the wall?" B: "Yes, and she seems to be settling into her new place nicely."
2. To die. Did you hear that Walter stuck his spoon in the wall? What a shame. I think the funeral is next Tuesday.