Hi all,
- I have two databases, one with APEX and another with an application schema.
- On the APEX machine, a standalone ORDS is running servicing APEX and the remote database with the application schema
- The application schema is REST enabled and protected with OAuth
- The application REST services are usable with Postman
- I want to expose these services as REST Enabled SQL in APEX
- When I create the REST Enabled SQL in APEX I get an error:
ORA-20001: Authentication failed. ORA-06512: at "APEX_230100.WWV_FLOW_ERROR", line 1473 ORA-06512: at "APEX_230100.WWV_FLOW_ERROR", line 1508
- During the creation, there is no option to specify the token URL.
I therefore assume APEX is trying to determine this URL by itself and does so incorrectly.
Postman:
- Add a GET request with OAuth2 client credentials and token URL
- Get the token
- Execute the GET request
APEX:
- Create an OAuth Web Credential
- Start the REST Enabled SQL service wizard
(Yes, I know the port number is different from the Postman URL. This is because I'm running the databases in Docker images, and from the APEX database I need to use 8080 and from my laptop 8023)
- Select the credentials
- Test the Service
- The error log from APEX reports:
APEX - ORA-20001: Authentication failed. ORA-06512: at "APEX_230100.WWV_FLOW_ERROR", line 1473 ORA-06512: at "APEX_230100.WWV_FLOW_ERROR", line 1508
What I suspect is that the request for the token is posted to http://localhost:8080/ords/freergw/oauth/token, in stead of http://localhost:8080/ords/freergw/omzis/oauth/token
I also have an unprotected schema in the same database, and this is working just fine:
Does anyone know how this requirement can be implemented?
Kind regards,
Rob