SetDiffVersions Procedure

This procedure finds differences in values in version-enabled tables for two savepoints and their common ancestor (base). It modifies the contents of the differences views that describe these differences.

Syntax

DBMS_WM.SetDiffVersions(
   workspace1  IN VARCHAR2,
   workspace2  IN VARCHAR2);

or

DBMS_WM.SetDiffVersions(
   workspace1  IN VARCHAR2,
   savepoint1  IN VARCHAR2,
   workspace2  IN VARCHAR2,
   savepoint2  IN VARCHAR2);

Parameters

Table 70-37 SetDiffVersions Procedure Parameters  

Parameter	Description
workspace1	Name of the first workspace to be checked for differences in version-enabled tables. The name is case sensitive.
savepoint1	Name of the savepoint in workspace1 for which values are to be checked. The name is case sensitive. If savepoint1 and savepoint2 are not specified, the rows in version-enabled tables for the LATEST savepoint in each workspace are checked.
workspace2	Name of the second workspace to be checked for differences in version-enabled tables. The name is case sensitive.
savepoint2	Name of the savepoint in workspace2 for which values are to be checked. The name is case sensitive.

Usage Notes

This procedure modifies the contents of the differences views (xxx_DIFF), which are described in Oracle9i Application Developer's Guide - Workspace Manager. Each call to the procedure populates one or more sets of three rows, each set consisting of:

• Values for the common ancestor

• Values for workspace1 (savepoint1 or LATEST savepoint values)

• Values for workspace2 (savepoint2 or LATEST savepoint values)

You can then select rows from the appropriate xxx_DIFF view or views to check comparable table values in the two savepoints and their common ancestor. The common ancestor (or "base") is identified as DiffBase in XXX_DIFF view rows.

Examples

The following example checks the differences in version-enabled tables for the B_focus_1 and B_focus_2 workspaces. (The output has been reformatted for readability.)

SQL> -- Add rows to "difference view" COLA_MARKETING_BUDGET_DIFF
SQL> EXECUTE DBMS_WM.SetDiffVersions ('B_focus_1', 'B_focus_2');

SQL> -- View the rows that were just added.
SQL> SELECT * from COLA_MARKETING_BUDGET_DIFF;

MKT_ID  MKT_NAME  MANAGER  BUDGET  WM_DIFFVER          WMCODE
------  --------  -------  ------  -----------         --------
   1    cola_a    Alvarez   2      DiffBase            NC
   1    cola_a    Alvarez   1.5    B_focus_1, LATEST   U       
   1    cola_a    Alvarez   2      B_focus_2, LATEST   NC      
   2    cola_b    Burton    2      DiffBase            NC      
   2    cola_b    Beasley   3      B_focus_1, LATEST   U       
   2    cola_b    Burton    2.5    B_focus_2, LATEST   U    
   3    cola_c    Chen      1.5    DiffBase            NC   
   3    cola_c    Chen      1      B_focus_1, LATEST   U   
   3    cola_c    Chen      1.5    B_focus_2, LATEST   NC  
   4    cola_d    Davis     3.5    DiffBase            NC  
   4    cola_d    Davis     3      B_focus_1, LATEST   U   
   4    cola_d    Davis     2.5    B_focus_2, LATEST   U   
         
12 rows selected.

Oracle9i Application Developer's Guide - Workspace Manager explains how to interpret and use the information in the differences (xxx_DIFF) views.