Hi,
some of my GET services are written as Source Type: Collection Query, some are PL/SQL. The Collection Query supports pagination with the limit/offset parameters out-of-the-box; for the PL/SQL ones, the developer has to code the pagination. No problem with that…
The problem is that I can't have parameters with the name “limit” and “offset” for the PL/SQL services! I get error 400 if I try. That's being reported previously. I can use the implict fetch_offset/fetch_size, but … they don't work with Collection Query.
Do I miss something? The goal is to have all GET services with the same paging paramters regardless of implementation. Otherwise the end-user of our services will be very confused why things serving exactly the same purpose are named differently.
ORDS is the latest 23.3
Best,
Plamen