I have to create a RESTful service and into the GET handler I have to call a pl/sql procedure. This service can take optional parameters (e.g. http://localhost:8080/ords/Orders/getOrders?status=Pending&orderID=1). How can I use the optional parameters into the pl/sql procedure, because I need to return the data based on them?
Thank you!
Define parameters for your REST API.
SOURCE_TYPE => URI ACCESS_METHOD => IN
Calling the API...
Here's actual code, full demo:
Disclaimer: I work for Oracle and am the product manager for Oracle REST Data Services.