Skip to Main Content
Forums

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SYS.WWV_DBMS_SQL_APEX invalid for older versions

partlycloudyJul 13 2022

@christian-neumueller-oracle On our Oracle 19.1 database, we upgraded APEX from 21.2 to 22.1. We also dropped the APEX_xxxxxx schemas for older versions.
The upgrade went well and APEX seems to be fine but the install logs show a couple of issues
A bunch of errors of the form ERROR: 15:19:35 Cannot create or replace synonym ORDS_METADATA.WWV_FLOW_COMPANIES for APEX_220100.WWV_FLOW_COMPANIES ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.
SYS schema has invalid package bodies for WWV_DBMS_SQL_APEX_200100 and WWV_DBMS_SQL_APEX_200200 because they refer to objects in APEX_200100 and APEX_200200 which no longer exist
How can we fix these errors?
Thanks
This post has been answered by Christian Neumueller-Oracle on Jul 14 2022
Jump to Answer

Comments

Processing

Post Details

Added on Jul 13 2022
#apex-discussions
1 comment
807 views
1 mention