Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Procedure Error

 
Skanda Raman
Ranch Hand
Posts: 205
Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.>
 
Skanda Raman
Ranch Hand
Posts: 205
Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
any help?
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Eshwar,

I really did not understand your procedure. Why don't you just use something like this?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic