Oracle/PLSQL: ORA-01403

Learn the cause and how to resolve the ORA-01403 error message in Oracle.

Description

When you encounter an ORA-01403 error, the following error message will appear:

• ORA-01403: no data found

Cause

You tried one of the following:

1. You executed a SELECT INTO statement and no rows were returned.
2. You referenced an uninitialized row in a table.
3. You read past the end of file with the UTL_FILE package.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Terminate processing of the data.