Mostrando entradas con la etiqueta no data found. Mostrar todas las entradas
Mostrando entradas con la etiqueta no data found. Mostrar todas las entradas

lunes, 23 de mayo de 2016

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