Executes an Oracle PL/SQL script. This operation takes the SQL script as an input and processes each statement in the database using JDBC.

This operation was 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. Run Destructive is new property and it defaults to false, so if you are running delete, truncate, drop statements then make sure to check this input on plugin operation on your workflow.

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	Property Code	Required	Description
JDBC URL	`FDJDBC_URL`	Yes	The JDBC URL of the database.
JDBC User	`FDJDBC_USER`	No	The username that will be used to connect with.
JDBC Password	`FDJDBC_PASSWORD`	No	The password of the username.
JDBC Driver Path	`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	Property Code	Required	Description

Inputs

Input Name	Input Code	Required	Description
User	`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.
Password	`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.
Script File	`FDJDBC_INP_FILE_NAME`	Yes	The path to the script to execute. If a relative path is given, the path will be assumed to be in the `FD_ARTIFACTS_DIR`.
Run Destructive	`FDJDBC_INP_RUN_DESTRUCTIVE`	No	This option allows destructive statements to be run. See Special Considerations below.
Ignore Compilation Warnings	`FDJDBC_INP_IGNORE_WARNING`	No	If checked, sql compilation warnings will be ignored. Otherwise, they will cause the execution to be marked as failed.

Outputs

Output Name	Required	Description

Artifacts

This operation consumes one or more SQL files, and an optional sequence file, from the artifacts repository.

Endpoint Selection

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

Endpoint Execution

This operation will randomly execute on one of the endpoint identified during selection.