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!

Are query string parameters working in ORDS?

3055110May 19 2017 — edited May 24 2017

My team is just learning to use ORDS and we want to use it to create RESTFul APIs. So far, the tests are succesful, but one crucial question is:

Are query string parameters working in ORDS?

e.g. Would the following query work and if yes, can you please provide us with an example for implementing it?

http:/xxxxxxxx:8080/ords/xxxxx/yyy/demo/{visible}?cat=4

The following query has been set up:

select * from xxxx where visible= NVL(:visible,visible) and tttt=nvl(:cat,rrrrr)

value 1 is working fine as a parameter in the URI like this: http:/xxxxxxxx:8080/ords/xxxxx/yyy/demo/1

But if I add ?cat=1 after the parameter, I get 500 error, as it assumes that the value of the parameter is now "1 ?cat=1"...

  • Error during evaluation of resource template: GET api/demo/{visible}, SQL Error Code: 1,722, SQL Error Message: ORA-01722: invalid number

Can you please help?

Thanks

This post has been answered by Franco Soldera on May 23 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 21 2017
Added on May 19 2017
7 comments
1,302 views