Changes
Updating data in an Oracle or SQL database via a workflow can be done by using a set of activities.
= Instructions =
# Establish a [[HowTo:Connect_To_Oracle_With_A_Workflow|OLEDB OLE database connection to an Oracle or SQL database]]. Once connected, it is necessary to model the table / column definitions, of the data to be udpated, in the workflow.# Use [[Activity:CreateOLEOracleScope (Activity)|CreateOLEOracleScope]] activity or [[Activity:CreateOLESQLScope (Activity)|CreateOLESQLScope]] to set up the connection.
# Place either a [[Activity:CreateOLETableScope (Activity)]] or a [[Activity:CreateOLEQueryScope (Activity)]] within the scope acticity to define the table you want to udate data.
# Iterate throw the fetched rows by using e.g. a '''for each''' activity.
