ORDS Web Service API Is Failing Wrapping the APEX PL/SQL APIs for Workspace User Created
(Doc ID 3049939.1)
Last updated on SEPTEMBER 26, 2024
Applies to:
Oracle Retail Data Storage Cloud Service - Version 24.1 and laterInformation in this document applies to any platform.
Goal
On: ORDS 24.1.101.0 version
The users have created ORDS Webservice API in RDS to call the PL/SQL APIs: CREATE_USER-Procedure
To create Users in <WORKSPACE_NAME_VALUE_1> Workspace.
When calling webservice to test, it fails and giving below error.
Out[21]: '{"Exception" : "ORA-20987: APEX - User <WORKSPACE_NAME_VALUE_1> requires ADMIN privilege to perform this operation."}'
Below is webservice the users have created in RDS Stage
https://<URL>/CreateWorkSpaceDeveloper
This API is just to create APEX User.
It has seen in Workspace, <WORKSPACE_NAME_VALUE_1> is workspace administrator.
Whenever the users invoke the same Package using a PL/SQL block in SQL Commands section in RDS APEX VIEWER it is working fine.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |