Deploy the application to the database. This operation requires one ore more exported SQL files, ithese files can be either specified by using the APEX SQL Files (FDAPEX_SQL_FILES) or the plugin will deploy the ".sql" files in the artifacts folder.
This plugin supports deploying the same APEX application to the same database. This requires setting the Offset.
- If the application has never been deployed and you do not currently have an offset, the plugin can generate the offset, just select Use APEX Offset (FDAPEX_USE_OFFSET). , make sure you note the offset value used and set the property APEX Offset value (FDAPEX_OFFSET) for the next deployment.
- If you know the Offset, select Use APEX Offset (FDAPEX_USE_OFFSET) and set the property APEX Offset value (FDAPEX_OFFSET).
You will also need to set the application id and change the alias.
Environment/Instance Properties
...
Property Name | Property Code | Required | Description |
---|---|---|---|
APEX Workspace Name | FDAPEX_WORKSPACE_NAME | No | The name of the workspace to deploy the application to. |
APEX Application Id | FDAPEX_APPLICATION_ID | No | Identifying number of application. |
APEX Application Name | FDAPEX_APPLICATION_NAME | No | The name of the application to deploy. |
APEX SQL Files | FDAPEX_SQL_FILES | No | Comma separated list of SQL files to be executed during deployment, they will be executed based on the order in the list |
APEX Offset value | FDAPEX_OFFSET | No | The offset value . The offset must be a positive integerduring application import. This value is used to ensure that the metadata for the Application Express application definition does not collide with other metadata on the instance. |
Use APEX Offset | FDAPEX_USE_OFFSET | No | Detemines if the plugin will attempt to set the Offset. |
APEX Oracle SID | FDAPEX_ORACLE_SID | Yes | The SID of the database that will be deployed to. |
Database Schema | FDAPEX_DB_SCHEMA | No | Used to set the parsing (owner) schema of the APEX application. |
APEX Application Alias | FDAPEX_ALIAS | No | APEX alphanumeric identifier unique within a workspace and page |
...
This operation will select all available endpoints associated to the environment/instance.
Endpoint ExecutionExecution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Special Considerations
This operation