There is a drain on each corner of the sunroof that lead to each of the four corners of the car... If you have a lot of evergreen leaves around, then yes... you may have a clogged one.
I haven't had a sunroof Camry, but I think you might be able to at least get to the drains by pulling the sunroof trim and getting to it from there... or find the drain behind the front wheel and blow air back up it...
Oh, and while you are at it, pull the back side of the front fenders and clean out those leaves.
-Charlie