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 22.4 and APEX 21.1 with RDS

User_PB3T4Jan 22 2023

Hello, members.
I'm a newbie to Oracle APEX. And I'm trying to install ORDS 22.4 and APEX 21.1 with AWS RDS Oracle Database. (APEX 22.1 was installed success with ORDS 21.1.0.174.1826 by the way)

I have a few questions.

* Does ORDS 22.4 supports APEX 22.2?
* It seems that the ords_installer_privileges.sql scripts require a user name. What user should I set during the APEX install?
* I got the following error during ords install. It seems to be a privilege error. Does someone know how to fix this error? (I didn't execute ords_installer_privileges.sql yet)

Oracle Application Express (APEX) - Amazon Relational Database Service (0 Bytes)I installed ORDS 22.4 with the following steps.
* Install type: [2] Update Database Pool and Install/Update ORDS Database. default
* Database Connection type: Basic
* Database HostName: Oracle RDNS FQDN
* Database listen port: 1521 (default)
* Database service name: orcl
* Dataabse user: admin
* Database password: admin password

The rest of the questions answered default values.
Best regards.

[*** script: allow_apex_entry_points.sql]
Found APEX 21.1.3. Migrating APEX entry points to ORDS PL/SQL Procedure Gateway
Allow List
Procedure APEX_ADMIN could not be added to allow list. (error -20034)
Procedure APEX could not be added to allow list. (error -20034)
Procedure F could not be added to allow list. (error -20034)
Procedure P could not be added to allow list. (error -20034)
Procedure WS could not be added to allow list. (error -20034)
Procedure Z could not be added to allow list. (error -20034)
Procedure APEX_APPLICATION.AJAX could not be added to allow list. (error -20034)
Procedure APEX_APPLICATION.SHOW could not be added to allow list. (error -20034)
Procedure APEX_AUTHENTICATION.CALLBACK could not be added to allow list. (error
-20034)
Procedure APEX_AUTHENTICATION.CALLBACK2 could not be added to allow list. (error
-20034)
Procedure APEX_AUTHENTICATION.LOGOUT could not be added to allow list. (error
-20034)
Procedure APEX_AUTHENTICATION.SAML_CALLBACK could not be added to allow list.
(error -20034)
Procedure APEX_AUTHENTICATION.SAML_METADATA could not be added to allow list.
(error -20034)
Procedure APEX_SESSION.EMIT_TIMEOUTS could not be added to allow list. (error
-20034)
Procedure APEX_UTIL.COUNT_CLICK could not be added to allow list. (error -20034)
Procedure APEX_UTIL.GET_BLOB could not be added to allow list. (error -20034)
Procedure APEX_UTIL.GET_BLOB_FILE could not be added to allow list. (error
-20034)
Procedure APEX_UTIL.GET_FILE could not be added to allow list. (error -20034)
Procedure WWV_FLOW.ACCEPT could not be added to allow list. (error -20034)
Procedure WWV_FLOW.AJAX could not be added to allow list. (error -20034)
Procedure WWV_FLOW.HELP could not be added to allow list. (error -20034)
Procedure WWV_FLOW.JS_MESSAGES could not be added to allow list. (error -20034)
Procedure WWV_FLOW.SHOW could not be added to allow list. (error -20034)
Procedure WWV_FLOW_CUSTOMIZE.ACCEPT could not be added to allow list. (error
-20034)
Procedure WWV_FLOW_CUSTOMIZE.SHOW could not be added to allow list. (error
-20034)
Procedure WWV_FLOW_CUSTOM_AUTH_STD.LOGIN_PAGE could not be added to allow list.
(error -20034)
Procedure WWV_FLOW_CUSTOM_AUTH_STD.LOGOUT could not be added to allow list.
(error -20034)
Procedure WWV_FLOW_CUSTOM_AUTH_STD.LOGOUT_THEN_GO_TO_PAGE could not be added to
allow list. (error -20034)
Procedure WWV_FLOW_CUSTOM_AUTH_STD.LOGOUT_THEN_GO_TO_URL could not be added to
allow list. (error -20034)
Procedure WWV_FLOW_CUSTOM_AUTH_STD.WS_LOGOUT could not be added to allow list.
(error -20034)
Procedure WWV_FLOW_FILE_MGR.GET_FILE could not be added to allow list. (error
-20034)
Procedure WWV_FLOW_FILE_MGR.GET_WS_FILE could not be added to allow list. (error
-20034)
Procedure WWV_FLOW_ITEM_HELP.SHOW_HELP could not be added to allow list. (error
-20034)
Procedure WWV_FLOW_ITEM_HELP.SHOW_PLUGIN_ATTRIBUTE_HELP could not be added to
allow list. (error -20034)
Procedure WWV_FLOW_LISTENER cannot be resolved and will not be added to allow
list.
Procedure WWV_FLOW_UTILITIES.GEN_POPUP_LIST could not be added to allow list.
(error -20034)
Procedure WWV_FLOW_UTILITIES.GET_THEME_FILE could not be added to allow list.
(error -20034)
Procedure WWV_FLOW_UTILITIES.SHOW_AS_POPUP_CALENDAR could not be added to allow
list. (error -20034)
Procedure WWV_FLOW_UTILITIES.SHOW_IR_HELP could not be added to allow list.
(error -20034)
ORDS migrated 0 entry points from APEX to ORDS PL/SQL Procedure Gateway Allow
List.

Comments
Post Details
Added on Jan 22 2023
10 comments
2,334 views