Oracle® Database Advanced Replication Management API Reference 10g Release 1 (10.1) Part Number B10733-01 |
|
|
View PDF |
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.
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.
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 |