I might get shot down for this, but I used this approach successfully many years ago on a boat that I used inshore for diving: I had a small pinhole type puncture. I inflated the boat, cleaned around the wound, and then applied waterproof silicone mastic (as from any DIY shop) and pushed the mastic with my fingers so that it went through the hole. When it dried, it formed a plug. I would not recommend this as a permanent solution, but it got us out of a difficulty and didn't let us down.
Other options: buy the proper patch kit and take a bit of time to do it carefully. I've had mixed results and I think the answer is be thorough and patient. Clean the surface well and use fresh glue.
For a single hole, you can buy one of those butterfly clamp patches that you push through and open up. However, they usually involve opening the hole up wider so I'd be reluctant to do that. The one time I used one of these in real life, however, it broke. That was 20+ years ago when they were a fairly new idea so I imagine they've improved since.
Personally, I distrust all "spray it in and slosh it about" products. I have never got one to work on a car or motorbike tyre and all you are doing is contaminating the inside surface possibly making a later proper repair more difficult or impossible.
__________________
|