Nope, no prescription necessary. Airport security is looking for threats to air travel safety, not for what gets you hard. And enough folks use Viagra, Cialis, whatever, that it is totally commonplace. And where is the cause for embarrassment anyway?
However, if you are transporting containers of medical liquid (insulin, for example), then ensure that these carry pharmaceutical labels identifying them as prescription medication.