Process Flow Parameters

Ever wondered how to pass values out of one process flow activity into another? The use of variables and activity parameter bindings is the key. In the example below process flows are used as the activities, the same applies for any activity with parameters.

In the image below, the process flow named MASTER has 2 child flows; CHILD and CHILD_1, an output parameter of the sub-flow CHILD is passed into the input parameter of another sub-flow CHILD_1. To do this, the output parameter must be stored in a local variable DATASTORE of the MASTER flow and this variable is then passed into the next activity as an input parameter.

owb_flow_param0.JPG

Another common query is how to actually add variables and parameters in the first place. This is done by selecting the Variables node or START1 node in the selected objects panel, and clicking on the green plus button, not exactly intuitive, but that's how its done;

owb_flow_param0.JPG

After the variable or parameter has been added, you can select it in the tree and change its properties in the Object Details panel. A couple of bits of info that its not obvious how they operate.

Comments:

is it possible to send me this mdl to show sample of parameter in workflow

Posted by guest on January 13, 2012 at 03:07 AM PST #

Hi

I don't have the MDL, there is another post here;
http://blogs.oracle.com/warehousebuilder/entry/process_flow_execute_a_map_for

Cheers
David

Posted by David on January 13, 2012 at 03:23 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today