Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS installation error

user5523930Jun 4 2025

Installed ORDS 25.1 in APEX 24.2, Tomcat 9.0.105.0, Java 17.0.13 but I am getting following warnin

WARNING: Procedure APEX_ADMIN could not be added to allow list.
The function or procedure is a common object.
You must execute the following as a common user:
begin APEX_240100.wwv_flow_listener.sync_ords_gateway_allow_list; end;
WARNING: ORDS migrated 0 entry points from APEX to ORDS PL/SQL
Procedure Gateway Allow List.

I used common user and executed begin APEX_240100.wwv_flow_listener.sync_ords_gateway_allow_list; end;

But still Apex entry point is failing from browser :-

Error Code: ORDS-22001

The procedure named apex could not be accessed, it may not be declared, or the user executing this request may not have been granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access. Check the spelling of the procedure, check that the execute privilege has been granted to the caller and check the configured security.requestValidationFunction function. If using the PL/SQL Gateway Procedure Allow List, check that the procedure has been allowed via ords_admin.add_plsql_gateway_procedure.

Please help.

thanks

Michael

Comments
Post Details
Added on Jun 4 2025
1 comment
266 views