Skip to Main Content

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!

Oracle Apex: Is it possible to change the parsing schema at runtime?

User_2KB18Jan 5 2021

We have an Apex application (version 20.1) and our users must be able to change the database schema at runtime via button click (preferably without logging in again). Currently we are solving this by installing our application multiple times, once per schema.
We recently discovered the function apex_export.get_application. We intend to use this function to bring our frontend under version control (finally!). We would like to deploy our application directly from the exported files. Having a single application, we would not have to mess with the internal component ids from the exported files.
Is it possible to install the application once and change the parsing schema via Pl/SQL code? Thank you!

Comments
Post Details
Added on Jan 5 2021
8 comments
1,695 views