Is it PVC or CPVC? Depending on what it is used for, I would cut out the pin hole and re-glue an appropriate connector onto it.
Product is called a coupling. Cut the pipe at the pinhole and install the coupling. You are asking for a future leak if you use the "wonder" products.
You were right not to try a "wonder" product. I tried rescue 911. It worked for about 10min then the leak was back. So I took the entire pipe off and replaced it today, NO MORE LEAK!!! Thanks again Arlene