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!

Custom pager for plsql service

JoepHMay 15 2019 — edited May 15 2019

We would like to provide the GET requests based on the results of a stored procedure (Source Type = PL/SQL)

i can understand that the automatic Pagination Size will not work in this scenario. Any ideas how to implement this?

BTW: I created a :pagesize parameter (querystring) and this works nicely.

A parameter :limit does not work, I guess that is reserved.

Cheers, Joep

This post has been answered by Olafur T on May 15 2019
Jump to Answer

Comments

Olafur T
Answer

Hi,

Sure check out this answer: ORDS pagination with PL/SQL source type

Pretty easy to do..

Regards

Oli

Marked as Answer by JoepH · Sep 27 2020
JoepH

Ah, great. Thanks

1 - 2

Post Details

Added on May 15 2019
2 comments
188 views