Executes an Oracle PL/SQL script. This operation takes the SQL script an input and processes each statement in the database using JDBC.
Please note that each statement in the SQL files must be delimited by a forward slash (/) on its own line. Also this operation supports intermixed regular SQL statements (non PL/SQL statements), however, these statements must not end with a semi-colon. See the Appendix for sample PL/SQL script file:
Environment/Instance Properties
Property Name | Required | Description |
---|---|---|
FDJDBC_URL | Yes | The JDBC URL of the database. |
FDJDBC_USER | No | The username that will be used to connect. |
FDJDBC_PASSWORD | No | The password for FDJDBC_USER. |
FDJDBC_DRIVER_PATH | Yes | Classpath for locating the JDBC Driver (e.g. for Weblogic - {ORACLE_HOME}/oracle_common/modules/ oracle.jdbc_11.2.0/ojdbc6.jar). |
Project Properties
Property Name | Required | Description |
---|---|---|
|
|
|
Inputs
Input Name | Required | Description |
---|---|---|
FDJDBC_INP_USER | No | The username that will be used to connect with. This input takes precedence over the environment instance scoped FDJDBC_USER property. This input is required if the FDJDBC_USER property is not specified. |
FDJDBC_INP_PASSWORD | No | The password for FDJDBC_INP_USER. This input takes precedence over the environment instance scoped FDJDBC_PASSWORD property. This input is required if the FDJDBC_PASSWORD property is not specified. |
FDJDBC_INP_FILE_NAME | Yes | The name of the script to execute. |
Outputs
Output Name | Required | Description |
---|---|---|
|
|
|
Artifacts
This operation consumes one or more SQL files, and an optional sequence file, from the artifacts repository.
...
Replacement Properties
See Appendix.