oracle-databaseplsqloracle-ordsplsql-gateway

HTTP POST request with raw body to ORDS PL/SQL Gateway?


I am using Oracle Database 12.2 and ORDS 18.3. Is it possible to make an HTTP POST request with a raw body (no parameters using application/x-www-form-urlencoded or multipart/form-data) to ORDS, knowing that ORDS is used only for its PL/SQL Gateway part, not the REST Data Services part.

In this scenario, ORDS in standalone mode (with Jetty) is the HTTP server. The HTTP client that makes the request is some external program (Postman, Java, ...).

The idea is to send JSON data but it could be binary data like an image or something else.

It looks like the PL/SQL Gateway is "only" able to invoke procedures using parameters (or no parameter at all but also of course no body). I am able to make a request with a dummy parameter in multipart form and somehow simulate what I want (tested with VARCHAR2, not CLOB nor BLOB) but I wanted to know if the possibility exists.


Solution

  • To answer my own question, it is not possible. We have to use a parameter and the MIME type application/x-www-form-urlencoded (or multipart/form-data).