DROP_ALL_USER_PARM_VALUES Procedure

This procedure drops user parameter values for a specific deployment template. This procedure is very flexible and enables you to define a set of user parameter values to be deleted.

For example, defining the parameters shown in the following table has the described results.

Parameter	Result of Defining the Parameter
`refresh_template_name`	Drops all user parameters for the specified deployment template
`refresh_template_name` and `user_name`	Drops all of the specified user parameters for the specified deployment template
`refresh_template_name` and `parameter_name`	Drops all user parameter values for the specified deployment template parameter
`refresh_template_name`, `parameter_name`, and `user_name`	Drops the specified user's value for the specified deployment template parameter (equivalent to `drop_user_parm`)

Syntax

DBMS_REPCAT_RGT.DROP_ALL_USER_PARMS (
   refresh_template_name   IN   VARCHAR2,
   user_name               IN   VARCHAR2,
   parameter_name          IN   VARCHAR2);

Parameters

Table 21-46 DROP_ALL_USER_PARMS Procedure Parameters

Parameter	Description
refresh_template_name	Name of the deployment template that contains the parameter values that you want to drop.
user_name	Name of the user whose parameter values you want to drop.
parameter_name	Template parameter that contains the values that you want to drop.

Exceptions

Table 21-47 DROP_ALL_USER_PARMS Procedure Exceptions

Exception	Description
miss_refresh_template	Deployment template name specified is invalid or does not exist.
miss_user	User name specified is invalid or does not exist.
miss_user_parm_values	Deployment template, user, and parameter combination does not exist in the `DBA_REPCAT_USER_PARM_VALUES` view.