Recently I had to get an ORDS remote procedure call to work on a CentOS / Apex 4.2 / ORDS 2.0.10 server. I had a hard time finding the right documentation for that old ORDS version, so I thought I'd share how I got it to work finally.
As database schema tedstruik:
As database schema sys:
As OS user oracle:
As OS user root:
In a browser:
Test using a URL like this: http://localhost:8090/ords/tedstruik.output_name?p_name=bob
Result: “Hello bob. You have successfully exposed your procedure using RESTful services.”
Note: sometimes Tomcat is slow to pick up changes, it seems. Wait a bit and/or restart Tomcat again if you get 503/404/403 errors.