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.
03 WRX Wagon 5spd
89 Camry Alltrac LE 3S-GTE 5spd
88 Camry Alltrac LE 5spd - blown motor
Previous: 90 Camry 3S-GTE, 90 Camry DX
Camry Parts FS