ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows

ORA-01422: exact fetch returns more than requested number of rows error when SELECT INTO statement returns more than one value.

Error Received:

ORA-01422: exact fetch returns more than requested number of rows

Solution:

This error can be fixed by choosing one of the following two options.

1. Refactoring the SELECT INTO statement to return only one row.

2. Replacing the SELECT INTO statement with a cursor.