Hi
I have an APEX application and I would like some of the data in the database to be made available via a web service that specified users outside of an apex environment would be able to consume.
What is the recommended way to achieve this
I have been following the guide Creating a RESTful Web Service with GET and PUT Resource Handlers
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/schema/50/Creating_RESTful_web_services/Creating_RESTful…
but when testing the feed I am getting the following 500 internal server error
Error during evaluation of resource template: GET my_webservice, SQL Error Code: 942, SQL Error Message: ORA-00942: table or view does not exist
Is there anything that needs to be set up on APEX /Oracle that could be causing the above problem, as my table does exist and I am running it from within the same schema.