...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Warning |
|---|
This operation is deprecated in release 4.0.3.10, and will be removed in a future release. All functionality is merged into |
...
the runScript operation. Please use that operation instead in your workflows. |
Executes an Oracle PL/SQL script. This operation takes the SQL script as an input and processes each statement in the database using JDBC.
...
| Property Name | Property Code | Required | Description |
|---|---|---|---|
| JDBC URL |
| Yes | The JDBC URL of the database. |
| JDBC User |
| No | The username that will be used to connect with. |
| JDBC Password |
| No | The password of the username. |
| JDBC 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 | Property Code | Required | Description |
|---|---|---|---|
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
| User |
| No | The username that will be used to connect with. This input takes precedence over the environment instance scoped |
| Password |
| No | The password for |
| Script File |
| Yes | The path to the script to execute. If a relative path is given, the path will be assumed to be in the |
Outputs
Output Name | Required | Description |
|---|---|---|
Artifacts
This operation consumes one or more SQL files, and an optional sequence file, from the artifacts repository.
...