Share this page
SQL*Plus plugin
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:
| 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 the * and ? characters as wildcards. |
| Oracle Home | (Optional) The ORACLE_HOME environment variable value. |
See also:
