Creating a 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.