I'd pick up one of these at the hardware store:
If you're not in North America, I'm sure there's a local equivalent.
Based on the LED's that light up, you can tell if the circuit is wired correctly. The only thing it can't detect is a ground/neutral swap. But it can detect a missing ground.
Outdoor Power - Do not power the camera using an outdoor outlet. You have all the problems you listed and you make the system more susceptible to tampering (an intruder can simply unplug the camera and blind the system).
Powering the camera - Let's begin by checking if the camera and its power supply is rated for outdoor use. The exposure to moisture, and to a lesser degree extreme temperature, makes many indoor units unsuitable. The connection of the power supply to the camera needs to be water resistant. If it is not, you need to consider a different camera unit.
In general, outdoor power lines need special cable or a metal or plastic pipe to protect the cable. The power to the unit is apparently low voltage, so it may not need the same level of protection as it would if it were 120 volts.
You will need to bring the wire through the wall (or through a soffit) at some point. You want to drill through an area that DOES NOT contain framing. You will go through siding, sheathing, probably insulation, and then finish material, probably drywall.
The main issue is sealing the entry holes from water and air infiltration. This can be done on the outside using a good outdoor caulk.
On the inside, you can use a low voltage junction box to protect the wire and then route it to an outlet. The best approach might be to run the wire to a double box, low voltage on one side and line voltage on the other.
You could then have the wire exit the front of the low voltage side and have the transformer plug into the line voltage side.
Mounting Camera - Most modern cameras (at least those without heavy housings or motor mounts) are fairly light, just a few pounds, if that. They can be screwed into the sheaving of the wall, which is located beneath the vinyl siding. You need to drill through the siding and into the sheathing and then screw the base to the sheathing. As you are mounting, you can seal the screw holes and even the base of the camera with outdoor caulk.
If the camera is heavy, you should screw the camera to a framing member (stud). These are found at corners, regularly spaced horizontally (usually every 16 inches from a corner), and near the roof and floor line of each level. You can use a stud finder to locate them.
Best Answer
It would be a code violation to use a cord for permanent wiring according to the NEC. It is not UL listed so it is not made for use in the US. Many devices found online have not passed safety evaluation.