The following macros are not currently supported in the header:
  • style

Export (APEX)

Owned by Brian Draheim (Unlicensed)
Last updated: Feb 20, 2017
1 min read

Export the APEX application to a SQL file.

Environment/Instance Properties

Property Name

Property Code

Required

Description

APEXExport Path

FDAPEX_APEXEXPORT_PATH

Yes

Directory path to the APEXExport class for example : C:\oracle\apex\utilities

Target JDBC Driver Path.
FDORA_DRIVER_PATH
YesPath containing JDBC driver for target database, for example: /u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar
Oracle Database URL
FDORA_URL
YesThe JDBC URL for the target Oracle database.
Oracle Database User
FDORA_USER
YesThe username that will be used to connect to the target Oracle Database.
Oracle Database Password
FDORA_PASSWORD
YesThe password for Oracle Database User.

Project Properties

Property Name

Property Code

Required

Description

APEX Application Id
FDAPEX_APPLICATION_ID
YesThe application id for the application to be exported.

Inputs

Input Name

Input Code

Required

Description





Outputs

Output Name

Required

Description




Artifacts

This operation produces a deployable APEX sql file artifact that will be stored in the artifacts repository.


Endpoint Selection

This operation will select all available endpoints associated to the environment/instance.


Endpoint Execution

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 requires that APEXExport command line utility is available on the endpoint.


The following macros are not currently supported in the footer:
  • style