Re: Error matching data:-1422:ORA-01422: exact fetch returns more than requested number of rows

I don't think the error comes from the code you have shown us. I guess you also have a "Select ... Into ... From .." in your procedure that returns more than 1 row.

"SharpBlade" <chretien_at_gofree.indigo.ie> wrote in message news:87133368.0209200639.76b376e5_at_posting.google.com...
> Hi there,
>
> I need some help to get rid of the above Oracle error that shows up
> when scanning through a cursor with FETCH statements. The logic is as
> follows:
>
> -----------------
> OPEN dum_cursor;
>
> LOOP
>
> FETCH dum_cursor INTO dum_cur_rec;
> EXIT WHEN dum_cursor%NOTFOUND;
>
> END LOOP;
>
> CLOSE dum_cursor;
> -----------------
>
> You would expect never to meet error 01422 when running the above
> logic as a cursor is used. Is there another reason why this exception
> could show up.
> Many thanks for any advice... Oracle newbie.
Received on Fri Sep 20 2002 - 20:53:26 CEST