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!

ORDS and PL/SQL Result Pagination

User_0DKA2Jun 7 2017 — edited Jul 21 2017

We are using the ORDS 3.0.8.* and if I invoke the PL/SQL stored procedure using the ORDS, I am having the following issues

1) Result pagination does't work, means all the results from PL/SQL will be send in one request.

2) Results are always in JSON format.

With SQL Statement, the result pagination and result format can be JSON or CSV, every thing is working fine. The issue is with PL/SQL

I was wondering, is it limitation in ORDS or do I miss something. 

Can you please help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2017
Added on Jun 7 2017
3 comments
1,339 views