Re: ORA-01422: exact fetch returns more than requested number of rows???
From: Igor Keselman <igor.keselman_at_ab.com>
Date: 1997/09/05
Message-ID: <34107629.CB342812_at_ab.com>#1/1
Date: 1997/09/05
Message-ID: <34107629.CB342812_at_ab.com>#1/1
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 CEST