i have requirement to delete huge data where i have to select data into small pieces and then delete it to avoid overload on database server. I have written a procedure for this, but it is not giving right output. I am getting error saying "one or more records are fetched". Can you please let me know where am i wrong.
here mytest table has 3 lakhs records. I want to select 1000 records everytime and delete them. Please help me.>