Having no idea what a P92 is, I've just Googled it and discovered it's a digital camera - it does help to give us as much information as possible when you ask for help.
What happens if you put the memory stick in a card reader? Are there any pictures on it it? If not, the camera sounds like toast to me. How old is it? Generally they're too fiddly to fix.