What does Oracle SQLCODE ORA-00942 signify

I will explain the sequence of actions.

1. The select returns no rows and throws an exception NO_DATA_FOUND
2. The WHEN OTHERS exception handler handles the exception.
3. the Raise_Application_Error should raise the new exception.

Problems:

• The use of the sqlcode variable is not wise, you should remove it as it is not within an error handler.
• The EXIT statements after the RAISE_APPLICATION_ERROR's are dead code.
• I cannot quite see how you could see the ora-00100 error with this code and still be correct in what you wrote.

Your OS is x86 but not amd64? It seems SGA setting larger than system limit. Set your oracle memory under 2GB.