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!

Get schema_owner, application id, application alias and workspace_id during apex app installation

Execcr2 hours ago

Hello,

i need to develop a customization script for one of my apex application. After some thinking, i decided to deploy the changes via an API REST during the end of the installation phase, using a supporting object custom installation script. Due to the fact that during installation i'm in the 4000 application, i cannot use v('XXXX') to get the parameters i need.

To univocally identify an application, i choose to create my “PK” using application_id, workspace_id, application_alias and schema owner.

I searched again and i found that the package APEX_APPLICATION_INSTALL have some get functions:

    `l_schema_name := APEX_APPLICATION_INSTALL.GET_SCHEMA;`  
   `l_workspace_id := APEX_APPLICATION_INSTALL.GET_WORKSPACE_ID;`  
   `l_application_id := APEX_APPLICATION_INSTALL.GET_APPLICATION_ID;`  
   `l_application_alias := APEX_APPLICATION_INSTALL.GET_APPLICATION_ALIAS;`

The problem is that only .GET_APPLICATION_ID is working, all the others three return null values.

Any hint?

Added 2 hours ago

#apex-discussions, #supportingobjects

0 comments

10 views