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.
