More info such as did you buy the car new, how often is the oil changed and checked, etc.
The oil pressure lamps signifies no oil pressure and normally you would not expect a 90k miles Camry to have a pressure problem unless there is a root cause for it.
This could be a shaky past maintenance history of irregular oil changes leading to sludging, etc.
Since the engine is apparently locked up due to a seized or spun rod bearing you will need to rebuild or replace it. What should be done first is to drop the oil pan off of the engine and take a look at 2 things.
One is the oil pan and oil pump pickup screen for signs of sludging.
Two is look at the crankshaft journals closely and see if any of them are dry in appearance and/or discolored. This is a sign of lack of lubrication and a bad bearing. This would, of course, mean all of the bearings are bad; just some worse than others.