I was using olive oil on my chain for a while, it being the only oil I had here and the bike was in the kitchen, so I thought, why not, better than it running dry. But the chain was completely shot anyway, a chain made up of bits of seventeen year old original Shimano IG and a few links of KMC Z51, cash was that tight at the time.
But now I have a new chain and a new cassette and jockeys on order, so I am thinking about less messy , longer lasting lubrication, easy when quick links are fitted.