The Oracle database is an object-relational database management system produced and marketed by Oracle Corporation. Oracle has these features:
The EC-Oracle plugin calls the Oracle SQL*Plus command-line tool that you use to execute SQL files against the database.
Plugin Version 220.127.116.112041506 Revised on April 14, 2022
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.
In the main menu, selectto 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.
This procedure creates and executes an SQL file against an Oracle database.
In the Main Menu, click Admin > Plugins to open the Plugin Manager.
Go to the ExecuteSQL procedure.
Enter the following parameters:
The name of the configuration that contains the user and password used to connect to the database server. (Required)
A query to run against the database.
Absolute path to the SQP*Plus command-line tool. (Required)
The name or IP address of the server to which you want to connect. (Required)
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, such as -S to activate the SQL*Plus silent mode.
For more commands, go to this website.
The directory where the commands are executed.
Result (output property path)
Property name used to store the query results.
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.
Fixed a bug where the clear text password appeared in the commandLine property created by the ExecuteSQL procedure. The clear text password also appeared in the ElectricFlow log file if the user ran the ExecuteSQL procedure.