Update Data via OLEDB with a Workflow

First you need to establish a OLEDB Connection t o a Oracle Database. See Connect To Oracle With A Workflow for details.

Once we are able to connect we start modelling the data structures we want to udpate in the workflow editor.
1. Use a "CreateOLEOracleScope" Activity to configure the connection.
2. Place either a "CreateOLETableScope" or a "CreateOLEQueryScope" inside the scope acticity to define the table you want to fetch data from.

When you are using a CreateOLEQueryScope to fetch data you want to update, you "have to" define a valid tablename!

3. Iterate throw the fetched rows by using e.g. a FOR - EACH activity.
4. Once you found the row you want to update, use an "OLEEditRow" to make it editable.
5. Define the primary key data structure by placing "EditOLEValue" activities inside the OLEEditRow. Yoe need to specify the column name in the "DisplayName" property and the data type in the "DataType" property. Check the "IsPrimary" checkbox as this column is the key column.

The primary key column "must be defined" when updating data via OLE DB.

6. Define the data cells you want to update by placing "EditOLEValue" activities inside the OLEEditRow. Yoe need to specify the column name in the "DisplayName" property and the data type in the "DataType" property. Specify the new value for the cell in the evaluation property "Value".

Example Workflows:

Connecting to oracle DB and reading data with a CreateOLETableScope: Example Workflow ORACLE UPDATE STATEMENT.uwf

Example Workflow