Plugin procedures can be used in procedure steps, process steps, and pipeline tasks, allowing you to orchestrate third-party tools at the appropriate time in your component, application process, or pipeline.
|
Depending on your plugin configuration and how you run procedures, the field may behave differently in the CloudBees CD/RO UI. For more information, refer to Differences in plugin UI behavior. |
ExecuteSQL
Executes an SQL file or query against an Oracle database.
Input parameters
| Parameter | Description |
|---|---|
Configuration name |
Required. The previously defined configuration for the plugin. |
Sqlplus path |
Required. Absolute path to the |
Server |
Required. Hostname or IP address of the server to connect to. |
Output file |
Name of the output file. Do not specify the file extension. |
Query |
Query to run against the database. |
SQL file path |
Absolute path to an SQL file. |
Additional commands |
Additional commands to be entered. |
Working directory |
Working directory where the command is executed. |
Result (output property path) |
Property name used to store the query results. |