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!

How do you turn off pagination?

jflackJul 3 2015 — edited Jul 7 2015

I'm using ORDS 3.0 production to create a query based GET service defined as a "Collection Query".  Works great, but pagination was set to 25.  This was great for testing, but in production, this particular service (basically a SELECT * from a view) is intended to let an outside party download an entire copy of the view - about 20,000 rows.  I tried setting pagination to "0" in SQL Developer, but it kept resetting it back to 25.  Bug maybe?  Or am I not understanding something?  Should it be a "Query" - I'm not sure I understand the difference between Collection Query and plain Query.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2015
Added on Jul 3 2015
4 comments
3,300 views