Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hi I am facing issue while fetching ORDS records limit more than 1000

wizardApr 20 2022

Hi , I am trying to fetch all tables records from ATP database using ORDS service but I am only getting 1000 records after setting ?limit=1001&offset=25 when I tried to fetch all records it fails or not fetch all records and gives below error.
Desire Result:
Want all the table data (either 1000 or 50 lakh) using ORDS service and want to show in VBCS table or in postman.
image.png

Comments
Post Details
Added on Apr 20 2022
7 comments
1,299 views