Oracle Database Update

Use this activity to execute an SQL UPDATE statement on Oracle Database. The Oracle Database Update activity returns information in the form of rows affected.

Settings

The Settings tab has the following fields:

Field Description
Oracle Database Connection Name of the Oracle Database connection from which to retrieve information. You can select the connection from the Oracle Database Connection drop-down list.

Input Settings

The Input Settings tab has the following fields:

Field Description
Update Statement An SQL statement used to update a record in the table. You can construct prepared SQL queries by using substitution variables (or parameters) of the form ?<fieldname> in the update query statement.

Each substitution variable identifies an input parameter whose mapped value is substituted in the substitution variable at runtime. You can reuse the substitution variable for the same input parameter elsewhere in the query. The input fields in the Input tab of the activity are populated based on the SQL UPDATE statement. You must include the semicolon (;) at the end of the query. This activity expects an update query to end with a semicolon to indicate the end of the query. A missing semicolon at the end results in the query hanging.

For now, only single table update queries are allowed.

  • Example of UPDATE query: 
    update student set roll_no = ?roll_no where name like
?name;

    For above update query, roll_no(NUMBER) and name(VARCHAR) are in the Inputs tab as these fields are used as parameters. Also, the mapped values for the fields name and roll_no are substituted in the substitution variables ?name and ?roll_no at runtime.

Manually Configure Metadata When schema retrieval fails due to non standard SQL, use Manually Configure Metadata. For more information, see Using Manually Configure Metadata Option.
Table Schema Displays the metadata of the SQL update statement. You can modify the column metadata if Manually Configure Metadata is set to True.
Note: If you modify the metadata, ensure that it is in agreement with the query added.

Input

The Input tab displays the input schema of the activity as a tree structure. The schema varies according to the object that you selected on the Input Settings tab. You can provide the input values in the Flogo Connector for Oracle Database mapping input fields directly or use Mapper to map the input values to a field from the output of a preceding activity in the flow.

Output

The Output tab displays the output schema of the activity as a tree structure. The output is read-only. The properties that are displayed in the schema correspond to the output of this activity and can be used as input by subsequent activities in the flow.