Assuming you are fetching the records from somewhere in the first place you would do something like:
open cursor loop bulk collect limit 500 into r forall i in 1 .. r.count delete... exit when r.count < 500 end loop close cursor
Of course, ideally you might be better off just with "delete where ... "
hth connor
On 5/12/05, cichomitiko gmail <cichomitiko@(protected)> wrote: > Thank you! > May be I have to try something like: >=20 > FORALL e IN 1..1000 -- bulk-bind first part of varray > DELETE PUSH_LIST_DELIVERY > WHERE ID_MSG_LIST=3Dt_ID_MSG_LIST(e); >=20 > FORALL e IN 1001..cont_tot -- bulk-bind the rest of varray > DELETE PUSH_LIST_DELIVERY > WHERE ID_MSG_LIST=3Dt_ID_MSG_LIST(e); >=20 > But I have to control the number of recors returned, so for example, if i= t's > 3000, then it should be: >=20
