The Oracle database is an object-relational database management system produced and marketed by Oracle Corporation. Oracle has these features:
-
Transaction support
-
Stability
-
Scalability
-
Multiplatform support
-
Security
The Oracle plugin calls the Oracle SQL Plus command-line tool that you use to execute SQL files against the database.
Plugin Version 2.0.10.2022041506 Revised on April 14, 2022
|
Setting up the plugin configuration
Plugin configurations are sets of parameters that apply across some or all of the plugin procedures. They reduce repetition of common values, create predefined sets of parameters for end users, and securely store credentials. Each configuration has a unique name that is automatically entered in designated parameters in the procedures.
Input
-
In the main menu, select
to open the plugin manager. -
Find the EC-Oracle row.
-
Click Configure to open the Oracle Configurations page.
-
Click Create Configuration.
-
To create an Oracle configuration, enter the following information and click OK.
Remember that you may need to create additional configurations later.
Plugin procedures
ExecuteSQL
This procedure creates and executes an SQL file against an Oracle database.
Input
-
In the Main Menu, click Admin > Plugins to open the Plugin Manager.
-
Go to the ExecuteSQL procedure.
-
Enter the following parameters:
Parameter | Description |
---|---|
Configuration name |
The name of the configuration that contains the user and password used to connect to the database server. (Required) |
Query |
A query to run against the database. |
Sqlplus path |
Absolute path to the SQP*Plus command-line tool. (Required) |
Server |
The name or IP address of the server to which you want to connect. (Required) |
Output file |
Name of a file where output is stored (without extension). |
SQL file path |
Absolute path to an SQL file that you want to run. |
Additional commands |
Additional commands, such as -S to activate the SQL*Plus silent mode. For more commands, go to this website. |
Working directory |
The directory where the commands are executed. |
Result (output property path) |
Property name used to store the query results. |
Release notes
EC-Oracle 2.0.3
-
Restricted usage of both Query and SQL file path parameters.
-
Fixed a bug when plugin could not open runCommandLine log file.
-
Fixed a bug with temp.sql file which was not found in some cases.