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

Michael A. Casillas wrote:
>
> Does anyone know what this error message means:
>
> ORA-01422: exact fetch returns more than requested number of rows
>
> Michael.

Michael,

This usually happens in the following code:

select last_name
into var
from emp
where first_name ='JOHN';

More then one last name can be returned here, but the statement is meant for the cases when exactly one record is returned. To work around this problem either use a cursor or put the abpve statement inside begin  ..
exception
..
end
block. Received on Fri Sep 05 1997 - 00:00:00 CDT