Pinholes have a habit of quadrupling in size or more when inflated. As has been pointed out, superglue is not a filler and is non-flexible and the rubber will pull away from the blob of it sooner or later leaving you back where you are. You could get away for a while with supergluing a rubber patch over it... but you're out of patches.
Just go to Wal-Mart, some other big box store, service station or hardware shop (surely you *can* walk to one of those in your town) and buy a repair kit. And let this be a lesson -- always restock your patch kit when you fix punctures.
At least no-one suggested using duct tape...