Re: Delete a row fetched by a cursor in a cursor loop

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 03 Aug 2004 01:14:16 GMT
Message-ID: <Xns9539B9874F74CSunnySD@68.6.19.6>

Albert Dupond <ad_at_ad.com> wrote in
news:410e5be7$0$31401$636a15ce_at_news.free.fr:

> Hello,
>
> I small example would be better than a lot of words.
> Can I do this ?
>

><<<

> declare
> cursor myCursor is select objectid from myTable where value = 'TEST';
> begin
> for myRecord in myCursor loop
> delete from myTable where objectid = myRecord.objectid;
> commit;
> end loop;
> end;
> >>>
>
>
> I would really appreciate to be able to do this but I am afraid of side
> effects, because I modify the cursor data set during its usage.
>
> Which precaution must I take ? Any advice welcome.
>
> Thanks a lot
>
> AD
>

If the data inmyTable gets modified (& COMMITted) after myCursor opens, this procedure will never see those changes.

What problem(s) do expect or want to avoid? Received on Mon Aug 02 2004 - 20:14:16 CDT