Oracle Warehouse Builder (OWB) Weblog

Process Flow Parameters

By david.allan on January 6, 2009 3:19 PM

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...

| TrackBacks (0)

More process flow basics - for loops

By david.allan on July 27, 2007 4:02 PM

Here we create a typical programming loop within the process flow iterating over a number of activities based on a numeric index. The flow created represents the following pseudocode;  assign_rslt := 0;  for (int iter_idx:=0; iter_idx < number_iterations; iter_idx++) {   ...

| TrackBacks (0)

Process Flow - Execute a map for all files in a directory - Part 2

By david.allan on July 6, 2007 1:57 PM

This note is a description of a useful expert (download at end) for generating process flow components for loading all files from a directory based on the design in the earlier post described here. The expert prompts for minimal information...

| TrackBacks (0)

File Listing/XMLType from a stored procedure

By david.allan on May 2, 2007 4:59 PM

Ever wondered how to get a list of file names in a directory from within the Oracle database? See post for more details on OWB. This is something I've done in 2 cases, one which happens to use the XML/SQL...

| TrackBacks (0)