Adding a delay - timer best solution?
789736Feb 26 2013 — edited Feb 26 2013Hi guys, I currently have a cursor which will probably go through say 500 records at a time and delete them. As this is done using a cursor and a for loop ie,
for c1 in c_rec loop
delete..
from table
where id = c_rec.id;
end loop;
The deletes are done pretty fast, one after another. What I want to do is insert a delay of say 2 seconds between each deletion. So instead of deleting them all in a matter of seconds it will take longer ie 2 seconds between each delete. I was wondering what would be the best way to do this? Should I make use of a timer somehow? (im pretty new to timers so may need a little guidance if that is the case, or perhaps there is a better method available?
Id be gratefull for any help.
Thanks.
Edited by: 786733 on 26-Feb-2013 04:31