Oracle Error: ORA-01422
Exact fetch returns more than requested number of rows
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 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!|