Retrieve the list of Child records - in batches

Hi,

Can someone help me with a solution here.

Scenario: Fetch all the child Contacts associated to a Promotion Product and send them to external system.There could be 10 contacts for Product or there can be 50,000 contacts

I dont think external system will be happy if I send 50,000 records in a single transaction. I am yet to figure it out the size limit from Siebel side too. So, trying to understand what are the options we have in this case. Lets say, is it possible to send the list of child records in a smaller number in multiple transactions?

Thanks,