There is a hole in the wall 墙上有个洞 （洞是穿墙而过的,故用in)
There is a picture in the wall 墙上有幅画 （画是挂在墙面上的,故用on)