|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 43 of 52
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.
DBMS_WM.SetDiffVersions( workspace1 IN VARCHAR2, savepoint1 IN VARCHAR2, workspace2 IN VARCHAR2, savepoint2 IN VARCHAR2);
Name of the first workspace to be checked for differences in version-enabled tables. The name is case sensitive.
Name of the second workspace to be checked for differences in version-enabled tables. The name is case sensitive.
Name of the savepoint in
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:
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.
The following example checks the differences in version-enabled tables for the
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.