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.
Action:
Rewrite the query or change number of rows requested.
 Add a comment
|
|
|
| Janna Wykers | Aug 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! |
