ORA-01403: no data found

Message:
ORA-01403: no data found

Cause:
No data was found from the objects.

Action:
There was no data from the objects which may be due to end of fetch.

Explanation and Troubleshooting Tips:
The most common reason for this error message is when an exact fetch query returns no records.
An exact fetch occurs when a query is run which returns results directly into bind variables (rather than the results being enumerated via a cursor, loop, bulk collect, etc).
If the query returns no rows, then the predefined exception NO_DATA_FOUND is raised, and if that exception is not caught and handled in the code, then you will see an ORA-01403: no data found error.

In the following example, if a matching record for some_key is not present, then the exception will be raised.

Depending on the circumstances, you may wish to catch the exception and act on it – such as providing a default value, or executing different code if the row was not present.

Provided the exception is caught and not re-raised, then an ORA-01403 error will not be thrown.

See also:

Posted in Explained, ORA codes, Troubleshooting Tips

Contribute further information: