CommitResolve Procedure

This procedure ends a conflict resolution session and saves (makes permanent) any changes in the workspace since BeginResolve Procedure was executed.

Syntax

DBMS_WM.CommitResolve(
   workspace  IN VARCHAR2);

Parameters

Table 70-5 CommitResolve Procedure Parameters  

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

Usage Notes

This procedure ends the current conflict resolution session (started by BeginResolve Procedure), and saves all changes in the workspace since the start of the conflict resolution session. Contrast this procedure with RollbackResolve Procedure, which discards all changes.

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 procedure was called by a user that does not have the WM_ADMIN_ROLE role or that did not execute the BeginResolve Procedure on workspace.

Examples

The following example ends the conflict resolution session in Workspace1 and saves all changes.

EXECUTE  DBMS_WM.CommitResolve ('Workspace1');