- Connect to OracleSQL
- Disconnect from OracleSQL
- Add User Access to DatabaseTable
- Backup Database
- Delete Row(s) from Table
- Insert Row(s) into Table
- Remove User Access from DatabaseTable
- Restore Database
- Run Query
- Select Row(s) from Table
- Export from Database
- Import into Database
NOTE: for the activities, ORACLE Database 11g Express Edition is used. By default, it creates a database called XE when installing, which will be used for all of the examples below.
...
- Connection (text box editor type) (type: object): the output from a Connect to OracleSQL activity.
Add User Access to
...
Table
This activity adds privileges for an user to a database table.
Activity Parameters
The Add User Access to Database Table activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
Execution: the activity will search for the user and for the table. If found, will attempt to grant permissions over the table to the provided user:
Backup Database
This activity creates an .dmp file backup for the selected 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 Oracle server. (This parameter is used only when the user wants to send an encrypted password from outside the workflow, 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.
...
Execution: the activity will delete all the rows from a table according to the given Where statement:
- the initial table content:
- the table content after deletion:
Insert Row(s) into Table
This activity inserts Row(s) on an Oracle Server database table.
...
Execution: the activity will insert the new row into the selected table. In the database, the row can be seen with the ID 3:
Remove User Access from
...
Table
This activity removes privileges for an user to a database table.
...
The Remove User Access from Database Table activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: boolean): outputs True or False if the execution was successful or not.
Restore Database
This activity restores a Database from a backup .dmp file.
...