Friday , December 2 2022

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.

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.

Melek Durdu
Author: Melek Durdu

About Melek Durdu

Leave a Reply

Your email address will not be published. Required fields are marked *