ORA-01422
exact fetch returned more than the requested number of rows requested_rows
- requested_rows: The number of requested rows.
Cause
The cause is one of the following:
- A SELECT statement was executed in the exact fetch mode and returned more rows than requested.
- In PL/SQL, a SELECT INTO statement returned more than one row.
- In PL/SQL, a DML RETURNING INTO statement returned more than one row.
Action
Choose the action corresponding to the cause as numbered:
- Increase the number of rows requested to accommodate the number of rows returned; or omit the exact fetch mode on the fetch call.
- In PL/SQL, use a FOR loop to process the rows.
- In PL/SQL, use BULK COLLECT to return values into a table.