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.

Back to top

See also: