RollbackResolve Procedure

This procedure quits a conflict resolution session and discards all changes in the workspace since BeginResolve Procedure was executed.

Syntax

DBMS_WM.RollbackResolve(
   workspace  IN VARCHAR2);

Parameters

Table 70-32 RollbackResolve Procedure Parameters  

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

Usage Notes

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

While the conflict resolution session is being rolled back, the workspace is frozen in 1WRITER mode.

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 quits the conflict resolution session in Workspace1 and discards all changes.

EXECUTE  DBMS_WM.RollbackResolve ('Workspace1');