I used RESTful Data Services → Enable Objects to REST-enable a table in schema B, and I’m now trying to create a REST Enabled SQL connection in Workspace A (where the parsing schema is also A).
However, I can’t get this to work.
The documentation states:
“Create a REST Enabled SQL service to execute SQL or PL/SQL defined in Oracle APEX components on a remote Oracle database.”
Does this mean that REST Enabled SQL cannot be used when the “remote” APEX components are actually in the same database, just in a different schema?