I have a RESTful Service that accepts a bind value to a query that ORDS will run for me.

How do I pass that bind to ORDS?

You can do it explicitly be defining it as part of the URI.

Or, you can use the classic web ?var=value to pass it.

ORDS supports both 🙂

Both Services run the same SQL

The only difference is the URI itself.

So how do I pass the ID on the simpler URI?

Easy, just include it on the call.

pass things in as needed/required

So, which one to use? I imagine it’s a matter of personal preference. For me the former seems more COLLECTION/RESOURCE-RESTy, and the latter seems more flexible.


I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

1 Comment

  1. Thanx man. You saved my life after migrating to Apex 18 from 4.2. I cannot change other external application behavior with REST calls with “old style” URI templates and I was terrified after getting “URI Template may contain only alphabetic, numeric, underscore, dash, period, and forward slash characters, or may contain a single trailing asterisk.” message from REST modules designer… Now I know how to design them I can still use “old style” URI call 🙂

Write A Comment