Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01422: exact fetch returns more than requested number of rows???

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

From: Ken Denny <kendenny_at_bnr.ca>
Date: 1997/09/05
Message-ID: <34101A9F.14FC@bnr.ca>#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.

It probably means you did a "SELECT <columns> INTO <variables> FROM <table> WHERE <condition>" and there was more than one row of the table which matched the conditions. When selecting into variables and there is more than one row, you need to use a cursor.

Hope this helps
Ken Denny
kendenny_at_bnr.ca Received on Fri Sep 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US