You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
2
Views
0
Comments
edited Apr 16, 2022 7:21AM in Autonomous Database

Summary:

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.


Code Snippet (add any code snippets that support your topic, if applicable):

{
    "fault": {
        "faultstring": "Body buffer overflow",
        "detail": {
            "errorcode": "protocol.http.TooBigBody"
        }
    }
}


Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!