The SQL*Plus plugin enables Deployment Automation to run SQL scripts during a deployment.
SQL*Plus provides access to the Oracle database using the command line to enter SQL, PL/SQL, SQL*Plus and operating system commands.
Run SQLPlus Script step
Use the Run SQLPlus Script step to run a SQLPlus script.
To use the plugin step, open your process and navigate to Database > SQLPlus in the Tools pane.
Note: We recommend that you use this step when you are running an SQL script to create an Oracle function.
The following table describes the step's properties:
|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 the * and ? characters as wildcards.|
|Oracle Home||(Optional) The ORACLE_HOME environment variable value.|