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.

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

Added on Jan 22 2023

#apex, #apex-discussions, #upgrade

7 comments

331 views