AlterSavepoint Procedure

This procedure modifies the description of a savepoint.

Syntax

DBMS_WM.AlterSavepoint(
   workspace      IN VARCHAR2,
   sp_name        IN VARCHAR2,
   sp_description IN VARCHAR2);

Parameters

Table 70-2 AlterSavepoint Procedure Parameters  

Parameter	Description
workspace	Name of the workspace in which the savepoint was created. The name is case sensitive.
sp_name	Name of the savepoint. The name is case sensitive.
sp_description	Description of the savepoint.

Usage Notes

An exception is raised if the user is not the workspace owner or savepoint owner or does not have the WM_ADMIN_ROLE role.

Examples

The following example modifies the description of savepoint SP1 in the NEWWORKSPACE workspace.

EXECUTE DBMS_WM.AlterSavepoint (`NEWWORKSPACE', 'SP1', 'First set of changes for 
scenario');