D.B.
It's going to be very difficult to find a camp for a 9 year old that is only for 4 nights. A week would be the minimum in most cases. Look into YMCA type camps, or Boy Scouts if you can support them (not everyone can). Specifically ask if they have an "Intro to Camping" type of program for first-timers. It's also very late for camp registrations and while you might find a place with a cancellation, you want to look at the ramifications of a camp already being up and running, with kids settled in, and then introducing your child to kids who are already in a routine. It can be difficult to break in later on.
Have you considered taking your child for a camping weekend, perhaps to a place with small cabins vs. tents? There are social activities that just crop up at campgrounds, with kids finding friends and going to the lake or for a hike together. That's a good way to start exposing kids to an outdoor experience with public bathrooms and showers, a disconnect from technology, and meeting up with people from all over. I would consider trying to do that a few times this summer, and spend the next 6 months researching overnight camps to find a good fit for next year. Also google camping expos and shows where different camps have exhibits and info booths. They will all throw their info at you, of course, but it's a good way to think of questions you have and issues to address with your son to get him prepared and to find the type of camp that would suit him best.