Oracle8i Replication Management API Reference Release 2 (8.1.6) A76958-01 |
|
Data Dictionary Views, 6 of 112
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.
Because DEFAULT_PARM_VALUE 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, 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:
Oracle8i Application Developer's Guide - Fundamentals for more information on using cursors. Also, see Oracle8i Application Developer's Guide - Large Objects (LOBs) for more information on using the DBMS_LOB package and LOBs in general. |
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|