- 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
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.
Connect to OracleSQL
This activity connects to a OracleSQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under OracleSQL category.
...
The Connect to OracleSQL activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Data Source (text box editor type) (type: string): the database name to connect to. In the screenshot above the default XE database is used.
- Password (password editor type) (type: string): the password for the provided username.
- 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).
- Server Name (text box editor type) (type: string): the name or IP of the SQL Server to connect to. If Oracle is installed on the same server where the activity is executed, then the field can remain blank. This field is recommended to be used when accessing an Oracle database created on a different server.
- Username (text box editor type) (type: string): the the username of the SQL Server Administrator.
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 Connect to OracleSQL activity:
...
- It can be used any user created for the database (for example, the user(s) used when creating a Workspace in Oracle Application Express).
The Read Only Output variable are the possible output values that the activity will provide:
...