Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle Database Error: ORA-01403      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-01403

Error Description:
No data found

Error 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.

In other words, this error occurs when a SQL statement, written within a PL/SQL block, does not fetch any data.

This may be because you executed a SELECT INTO statement and no rows were returned, or you referenced an uninitialized row in a table, or because you read past the end of file with the UTL_FILE package.

Action:
Terminate processing for the SELECT statement.

This error is often associated with the SELECT INTO clause. To avoid ORA-01403, the PL/SQL has to contain exceptions or the query will offer no values to the defined variable. If the exceptions are not defined properly, you will encounter ORA-01403.


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 166 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?