- Connect to OracleSQL
- Disconnect from OracleSQL
- Add User Access to Database
- Backup Database
- Delete Row(s) from Table
- Insert Row(s) into Table
- Remove User Access from Database
- Restore Database
- Run Query
- Select Row(s) from Table
- Export from Database
- Import into Database
...
- Backup Path (text box editor type) (type: string): the path where the backup file will be created. The path can be manually written or selected by clicking the
button. - BackupName (text box editor type) (type: string): the name of the backup file that will be created. Should be a .dmp extension file (E.G. XE.dmp, where XE is the name of the current database).
- exp.exe Path (text box editor type) (type: string): the the path of exp.exe (the Oracle export utility), or select it with the File Browser. By default, exp.exe is located in C:\oraclexe\app\oracle\product\11.2.0\server\bin\ folder, where C:\oraclexe\app\oracle\product\11.2.0\server\ is also the value for the ORACLE_HOME environment variable.
- Password (password editor type) (type: string): the password for the provided username. The password should be the same as the one given for the Connect to OracleSQL activity. The Backup Database activity creates a connection string based on the user provided at the connection activity and the password provided in the backup activity.
- Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster Portal).
- SID (text box editor type) (type: string): the Oracle SID (Oracle System Identifier, which is used to distinguish Oracle database instances). By default it will be set to XE, which is also the Oracle's default database name.
...
This activity runs a query on a SQL an Oracle Server database.
Activity Parameters
The Run Query activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Query (text box editor type) (type: string): the SQL query string. For example: CREATE Table.
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Run Query activity:
...
- "SELECT Name, Company FROM FLOWSTERNAMESs where ID>1 and ID<4 order by name ASC"
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: collection<collection<string>>): outputs a collection of returned rows.To use the elements of the collection, use ForEachFactory activity.
- Output Columns (type: int32): outputs the number of columns returned.
- Output Rows (type: int32): outputs the number of rows returned.
Execution: In the Tracking Data there can be seen the returned results:
The same result can be seen when executing the same SQL Select query from Oracle Application Express:
Select Row(s) from Table
...