Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Export the APEX application or REST Service to a SQL file.

Environment/Instance Properties

APEX Workspace Name

Property Name

Property Code

Required

Description

APEXExport Path

FDAPEX_WORKSPACEAPEXEXPORT_NAMEPATH

Yes

The name of the workspace to deploy the application to.

APEX Application Id
FDAPEX_APPLICATION_ID
YesIdentifying number of application.

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.

...

APEX List separated by commas of language codes to be published

Property Name

Property Code

Required

Description

APEXExport PathAPEX Application Id
FDAPEX_APEXEXPORTAPPLICATION_PATHID
Yes

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

Oracle Database Home
FDAPEX_ORACLE_DB_HOME
YesOracle Database Home for example : /u01/app/oracle/product/11.2.0/dbhome_1
Target JDBC Driver Path.
FDORA_DRIVER_PATH
YesPath containing JDBC driver for target database connection.
APEX Languages to Publish
FDAPEX_LANG_TO_PUBLISH
NoThe application id for the application to be exported.

Inputs

Input Name

Input Code

Required

Description





...

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.

...

This operation requires that APEXExport command line utility is available on the endpoint.When exporting an application, either the APEX Application Name (FDAPEX_APPLICATION_NAME)