Oracle Error ORA-00100: no data found

Oracle Error Message

ORA-00100: no data found

Reason for the Error

An application made a reference to data that was unknown or inaccessible or that doesnot exist.

Solution

This error must be dealt with within the application. Modify the application as needed. If the application uses Oracle-mode SQL rather than ANSI-mode SQL, ORA-01403 will be generated rather than ORA-00100.