I have a table with 375,000 records and have enabled the REST API on this table using ORDS 24.1. My goal is to retrieve the records in batches of 50,000, but when I set the limit to 50,000 in the API request, it only returns a maximum of 10,000 records.
I tried creating a custom module in SQL Developer to modify this behaviour, but the limit resets to 10,000 whenever I save the module.
Is there a way to fetch more than 10,000 records in one go using ORDS?
Any advice or workarounds would be greatly appreciated!
