7 Replies Latest reply on May 24, 2017 12:47 PM by Franco Soldera

    Are query string parameters working in ORDS?

    3055110

      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