Hi Sam,
The reason I have a commit there is becuase the cursor fetches mote than a million records and deleteing them without committing will run out of rollback space.

The only reason I am using a cursor here is to do commits otherwise I could have used a simple delete command.

Is there any other way i can delete a million rows.

Thanks
Anurag