Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Referencing Apex schema objects and APIs from other schemas

Naama PazJan 22 2023

Hello
We are currently using the Apex 20.01 version and we are about to upgrade to 22.02
We found hard coded reference of objects/API of schema APEX_200100 (Lke: APEX_200100.WWV_FLOWS) from other schema in some applications/db

During this upgrade we need to treat all this hard coded reference and change it because current schema will be 220200 (APEX_220200.WWV_FLOWS)

What is the best way to references Apex schema objects from other schema?
Is using public synonym the best way to resolve this issue? Do you have any recommendations for that referencing?
Best regard
Naama

Comments
Post Details
Added on Jan 22 2023
6 comments
209 views