The Run Oracle Script action creates a step to run SQL scripts against an Oracle database.  It generates a SQL*Plus statement from the inputs and runs it.

 

 

 

User ID: The user account to login as (required).

 

Password: The user's password (optional).

 

Database/SID: The database of SID to connect to (optional).

 

Script file: The SQL script file to run (required).

 

Additional command-line options: Allows for any additional SQL*Plus command options to be entered and passed through.  See the SQL*Plus documentation for details on the available options.

 

SQL*Plus executable filename: If not specified, the action will invoke the sqlplus.exe command-line tool (it must be in the PATH environment variable).  This can be overridden by providing the executable filename and path in this field.

 

Log command-line constructed for call: Determines if the SQL*Plus command-line is logged.