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

Error Description:
Exact fetch returns more than requested number of rows

Error Cause:
The number specified in exact fetch is less than the rows returned.

Rewrite the query or change number of rows requested.

Add a comment 
Janna WykersAug 1st, 2010 9:43pm
This stumped me at first. It means that you're trying to execute a SELECT ... INTO ... inside a PL/SQL block, but the SELECT is returning more than 1 row. A SELECT INTO always needs to return a single row. If there is more than 1 row coming back then this is the error that gets generated. If there are no rows returned you'll get the "ORA-01403: No data found" error message. Hope this helps someone!
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 85 users online    © 2009 psoug.org

Forgot your password?