Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

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.