BeginResolve Procedure

This procedure starts a conflict resolution session.

Syntax

DBMS_WM.BeginResolve(
   workspace  IN VARCHAR2);

Parameters

Table 70-4 BeginResolve Procedure Parameters  

Parameter	Description
workspace	Name of the workspace. The name is case sensitive.

Usage Notes

This procedure starts a conflict resolution session. While this procedure is executing, the workspace is frozen in 1WRITER mode.

After calling this procedure, you can execute ResolveConflicts Procedure as needed for various tables that have conflicts, and then call either CommitResolve Procedure or RollbackResolve Procedure. For more information about conflict resolution, see Oracle9i Application Developer's Guide - Workspace Manager.

An exception is raised if one or more of the following apply:

• There are one or more open regular transactions in workspace.

• The user executing BeginResolve Procedure does not have the privilege to access workspace and its parent workspace.

Examples

The following example starts a conflict resolution session in Workspace1.

EXECUTE  DBMS_WM.BeginResolve ('Workspace1');