Error matching data:-1422:ORA-01422: exact fetch returns more than requested number of rows
From: SharpBlade <chretien_at_gofree.indigo.ie>
Date: 20 Sep 2002 07:39:14 -0700
Message-ID: <87133368.0209200639.76b376e5_at_posting.google.com>
[Quoted] Hi there,
OPEN dum_cursor;
Date: 20 Sep 2002 07:39:14 -0700
Message-ID: <87133368.0209200639.76b376e5_at_posting.google.com>
[Quoted] 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 - 16:39:14 CEST