ALL_REPCAT_TEMPLATE

ALL_REPCAT_TEMPLATE_PARMS

Contains parameters defined in the object DDL for all templates accessible to the current user. When an object is added to a template, the DDL is examined for variables. Any found parameters are automatically added to this view.

You can also define default parameter values and a prompt string in this view. These can make the templates easier to use during the instantiation process.

See Also:

ALL_REPCAT_TEMPLATE_OBJECTS

Related Views:

DBA_REPCAT_TEMPLATE_PARMS describes the template parameters for all deployment templates in the database.

USER_REPCAT_TEMPLATE_PARMS describes the template parameters for all deployment templates owned by the current user.

Column	Datatype	NULL	Description
`REFRESH_TEMPLATE_NAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the deployment template.
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	The owner of the deployment template.
`REFRESH_GROUP_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the refresh group to which the template objects are added to during the instantiation process.
`TEMPLATE_COMMENTS`	`VARCHAR2(2000)`	-	User specified comments.
`PUBLIC_TEMPLATE`	`VARCHAR2(1)`	-	If `Y` then the deployment template is public. If `N` then the deployment template is private.
`PARAMETER_NAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the parameter.
`DEFAULT_PARM_VALUE`	`CLOB(4000)`	-	The default parameter value.
`PROMPT_STRING`	`VARCHAR2(2000)`	-	The prompt string for the parameter.
`USER_OVERRIDE`	`VARCHAR2(1)`	-	If `Y` then the user can override the default parameter value. If `N` then the user cannot override the default parameter value.

Because the DEFAULT_PARM_VALUE column is defined as a CLOB, you receive an error if you simply try to perform a SELECT on the ALL_REPCAT_TEMPLATE_PARMS view. If you do not need to see the default parameter value, then use the following select statement (be sure to exclude DEFAULT_PARM_VALUE):

SELECT REFRESH_TEMPLATE_NAME, OWNER, REFRESH_GROUP_NAME, TEMPLATE_COMMENT,  
  PUBLIC_TEMPLATE, PARAMETER_NAME, PROMPT_STRING, USER_OVERRIDE 
  FROM DBA_REPCAT_TEMPLATE_PARMS;

The following script uses cursors and the DBMS_LOB package to view the entire contents of the ALL_REPCAT_TEMPLATE_PARMS view. Use this script to view the entire contents of the ALL_REPCAT_TEMPLATE_PARMS view, including the DEFAULT_PARM_VALUE column:

SET SERVEROUTPUT ON

DECLARE
  CURSOR mycursor IS
        SELECT REFRESH_TEMPLATE_NAME, OWNER, REFRESH_GROUP_NAME,
          TEMPLATE_COMMENT, PUBLIC_TEMPLATE, PARAMETER_NAME, DEFAULT_PARM_VALUE,
          PROMPT_STRING, USER_OVERRIDE
          FROM DBA_REPCAT_TEMPLATE_PARMS;
  tempstring VARCHAR2(1000);
  len NUMBER;
BEGIN
  FOR myrec IN mycursor LOOP
        len := DBMS_LOB.GETLENGTH(myrec.default_parm_value);
        DBMS_LOB.READ(myrec.default_parm_value, len, 1, tempstring);
        DBMS_OUTPUT.PUT_LINE(myrec.refresh_template_name||' '||
          myrec.owner||' '||myrec.refresh_group_name||' '||
          myrec.template_comment||' '||myrec.public_template||' '||
          myrec.parameter_name||' '||tempstring||' '||myrec.prompt_string||' '||
          myrec.user_override);
  END LOOP;
END;
/

See Also:

Oracle Database Application Developer's Guide - Fundamentals for more information on using cursors. Also, see Oracle Database Application Developer's Guide - Large Objects for more information on using the DBMS_LOB package and LOBs in general.