Executes an Oracle PL/SQL script. This operation takes the SQL script as an input and processes each statement in the database using JDBC.
...
Environment/Instance Properties
Property Name | Required | Description |
|---|---|---|
| Yes | The JDBC URL of the database. |
| No | The username that will be used to connect. |
| No | The password for |
| 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 |
|---|---|---|
| No | The username that will be used to connect with. This input takes precedence over the environment instance scoped |
| No | The password for |
| 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.
...
Sequence File for multi-file processing:
If you want to execute multiple SQL scripts, instead of specifying a SQL file within the FDJDBC_INP_FILE_NAME input, a file containing an ordered list of SQL files to execute may be given. The plugin will detect whether a SQL file or a sequence file has been specified based on the format of the file. The format of a sequence file is as follows:
...