Changes

First you need to establish a OLEDB Connection t o a Oracle Database.See [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details.<br/><br/>Once we are able to connect we start modelling the Updating data structures we want to udpate in the an Oracle database via a workflow editor.<br/><br/>1. Use can be done by using a "CreateOLEOracleScope" Activity to configure the connectionset of activities.<br/><br/>2. Place either a "CreateOLETableScope" or a "CreateOLEQueryScope" inside the scope acticity to define the table you want to fetch data from.<br/>{{Attention|When you are using a CreateOLEQueryScope to fetch data you want to update, you '''have to''' define a valid tablename!}}

3= Introduction =# Establish a [[HowTo:Connect_To_Oracle_With_A_Workflow|OLEDB connection to an Oracle database]]. Once connected, it is necessary to model the table / column definitions, of the data to be udpated, in the workflow.# Use [[CreateOLEOracleScope (Activity)|CreateOLEOracleScope]] activity to set up the connection.# Place either a [[CreateOLETableScope (Activity)]] or a [[CreateOLEQueryScope (Activity)]] within the scope acticity to define the table you want to udate data.{{Attention|If you are using a CreateOLEQueryScope to fetch data you want to update, you '''have to''' define a valid tablename!}}# Iterate throw the fetched rows by using e.g. a FOR - EACH '''for each''' activity.<br/><br/>4. # Once you found determine the row you want to updatebe updated, use an "[[OLEEditRow" (Activity)]] to make it editablestart editing.<br/><br/>5. # Define the primary key data structure column(s) by placing "using [[EditOLEValue" (Activity)]] activities inside the within OLEEditRow. You need to specify the column name in the "'''DisplayName" ''' property and the data type in the "'''DataType" ''' property. Check the "'''IsPrimary" ''' checkbox as for all columns defined in this column is the step (key columncolumns).

{{Attention|The primary key column "'''must be defined" ''' when updating data via OLE DB.}} 6. # Define the data cells you want column(s) to update be updated by placing "using EditOLEValue" activities inside within the OLEEditRow. You Again, you 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"'''.<br/><br/> 

'''Example Workflows:'''<br/><br/>=Examples=Connecting to oracle DB an Oracle database and update updating data: .[[File:Example_Workflow_ORACLE_UPDATE_STATEMENT.uwf|220px|border|alt=Example Workflow|Example Workflow]]<br/><br/>