Learn the reason and how to resolve the ORA-01422 error message in Oracle.
When you stumble upon an ORA-01422 error, the following error message will appear:
ORA-01422: actual fetch returns extra than requested range of rows
You tried to execute a SELECT INTO announcement and greater than one row was returned.
The option(s) to resolve this Oracle error are:
Rewrite your SELECT INTO declaration so that solely one row is returned.
Replace your SELECT INTO statement with a cursor.
For example, if you tried to execute the following SQL statement:
SELECT supplier_id INTO cnumber FROM suppliers WHERE supplier_name = 'IBM';
And there was more than one record in the suppliers table with the supplier_name of IBM, you would obtain the ORA-01422 error message.
In this case, it would possibly be greater prudent to create a cursor and retrieve each row if you are not sure of how many information you may retrieve.