Dimitri Gielis has written an excellent
blog post on integrating
Oracle Application Express with the
Oracle Social Network using the
APEX_WEB_SERVICE API. He has even shared the code on a project on
GitHub. If you ever have a need to integrate Application Express with a RESTful web service, I recommend you check out Dimitri's work for a good example.