I got ” ORA-01403: no data found ” error in Oracle database.
ORA-01403: no data found
Details of error are as follows.
ORA-01403 no data found Cause: In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query. Action: Terminate processing for the SELECT statement
no data found
This ORA-01403 errors are related with the host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query.
Mostly you can get this error during SELECT INTO statement usage and no rows were returned.
Or You have referenced uninitialized row in table.
You can terminate processing for the SELECT statement.
Or if you want to avoid ORA-01403, your PL/SQL code has to contain exceptions ,
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )