Anything will work as a chain lubricant, over a short enough timeframe. Sure, single/multi-weight motor oil will work, but it's absolutely not what it was designed for. It will make the chain a jet black, filthy mess rather quickly, but it will stop rust from forming and probably keep things squeak-free.
__________________