One time, it worked every time.  However the soda was tab,  which instantly kills ghosts for a second time. for good.