Oracle® Database Advanced Replication Management API Reference 10g Release 1 (10.1) Part Number B10733-01 |
|
|
View PDF |
This view describes the template parameters for all deployment templates accessible to the current user. The DBA has the option of building a table of user parameters prior to distributing the template for instantiation. When a template is instantiated by a specified user, the values stored in the ALL_REPCAT_USER_PARM_VALUES
view for the specified user are used automatically.
DBA_REPCAT_USER_PARM_VALUES
describes the template parameters for all deployment templates in the database.USER_REPCAT_USER_PARM_VALUES
describes the template parameters for all deployment templates owned by the current user.
Because DEFAULT_PARM_VALUE
and PARM_VALUE
columns are defined as CLOB
datatypes, you receive an error if you simply try to perform a SELECT
on the ALL_REPCAT_USER_PARM_VALUES
view. If you do not need to see the default or user parameter values, then use the following select statement (be sure to exclude DEFAULT_PARM_VALUE
and PARM_VALUE
):
SELECT REFRESH_TEMPLATE_NAME, OWNER, REFRESH_GROUP_NAME, TEMPLATE_COMMENT, PUBLIC_TEMPLATE, PARAMETER_NAME, PROMPT_STRING, USER_NAME FROM DBA_REPCAT_USER_PARM_VALUES;
The following script uses cursors and the DBMS_LOB
package to view the entire contents of the ALL_REPCAT_USER_PARM_VALUES
view. Use this script to view the entire contents of the ALL_REPCAT_TEMPLATE_PARMS
view, including the DEFAULT_PARM_VALUE
and PARM_VALUE
columns:
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, PARM_VALUE, USER_NAME FROM DBA_REPCAT_USER_PARM_VALUES; tempstring VARCHAR2(1000); tempstring2 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||' '|| tempstring2||' '||myrec.user_name); 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 |