Search code examples
oraclebind-variablesoracle-ords

Oracle ORDS 19.2: URI Template with multiple bind variables?

-currently testing through Postman-

want a guide for this as:

  1. i do not want to expose the parameters and their values in URL.

  2. when using URI Template like myuri/:bindvar (single bind variable) then i can send parameters in Body.

  3. but when creating Handler's parameters ( multiple ) i can get successful message and update sending those through Parameter tab but i can't access successfully sending those parameters through Body, parameter values are null.

  4. the sample from oracle have 3 Templates contain bind variables in URI but all are have single bind variable.

Solution

  • You only need to supply the values you want to return as response

    enter image description here

    Otherwise, there's nothing special about coding a PUT handler in ORDS compared to a GET or POST - You just need to build up your PLSQL block to do the work, in this case an UPDATE, and then build out the response you want to send back to your REST API consumer.

    Full example and code here