Create Oracle plugin procedures

1 minute readExtensibilityDeveloper productivity
On this page

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.

ExecuteSQL

Executes an SQL file or query against an Oracle database.

Input parameters

Table 1. ExecuteSQL input parameters
Parameter Description

Configuration name

Required. The previously defined configuration for the plugin.

Sqlplus path

Required. Absolute path to the sqlplus CLI.

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.