denrepo

Oracle error

ORA-01422

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

What usually causes it

A PL/SQL SELECT ... INTO returned more than one row.

What to check first

Tighten the WHERE clause, or handle TOO_MANY_ROWS in the block.

Open in the error lookupOracle's reference