It depends on the card brand, region, and Sony's current payment processor.
If the prepaid card is a generic Visa/MC/Amex gift card with AVS registration, it usually works. Carrier-branded "Network" cards often don't.