Run SQLPlus Script Step

This step runs a SQLPlus script.

Note: It is recommended that you use this step when you are running an SQL script to create an Oracle function.

Required properties:

Property Name	Description
SQLPlus Executable	The full path to the sqlplus executable, the scripts to be run, or the command to be run, if it is on the path.
Username	The username used to run the scripts.
Password	The password of the user.
Connection ID	The connection ID to be used. For example: `localhost:1521/ORCL`.
SQL Files	A newline-separated list of SQL files to be executed. Order is preserved. Supports ‘*’ and ‘?’ as wildcards.

Optional properties:

Property Name	Description
Oracle Home	The ORACLE_HOME environment variable value.