REST Service Source Type PL/SQL allow limit and offset for manual pagination

mahage Public · May 31 2023

Idea Summary
Currently it is not allowed to use the reserverd parameters limit and offset for REST request based on source type PL/SQL, e. g. GET ?offset=3&limit=5

To implement a manual pagination I have to use other parameter names than the common limit (:fetch_size) and offset (:fetch_offset) parameters. It would be great to have access to these and maybe other implicit parameters as well.

Use Case
As an user I am able to implement a manual pagination using the common parameters limit and offset for my RESTful Service based on source type PL/SQL.

Preferred Solution (Optional)

We reviewed this idea carefully and came to the conclusion that it does not constitute an appropriate APEX feature request.

Comments

carsten.czarski APEX Team OP 2.1 years ago (edited 2.1 years ago)

you are talking providing REST APIs, (REST Modules, Templates and Handlers), right?

Although this can be maintained in SQL Workshop in APEX; it's actually in the area of ORDS, so you might raise the idea in the ORDS forum: https://forums.oracle.com/ords/apexds/domain/dev-community/category/oracle_rest_data_services

5 Voters

REST Service Source Type PL/SQL allow limit and offset for manual pagination

Feature

Comments

Comments