There are around 1 crore records in a table. I want to download all the 1 crore record in a file. For this i want to extract 2,50,000 in each select using package size of 250000. Then would download 2,50,000 to a file. In next loop , again would extract and download 2,50000 records . Similarly would be creating files for 250000 records each.
But the problem is that, when i use select package size ... endselect, within that i m using a function module, because of which there is a commit work being exectuted and hence i m getting a short dump and the second loop is not getting executed.
Please let me know the solution asap.