Oracle8i Replication Management API Reference
Release 2 (8.1.6)

Part Number A76958-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Data Dictionary Views, 9 of 112


ALL_REPCAT_USER_PARM_VALUES

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.

Related views:

Because DEFAULT_PARM_VALUE and PARM_VALUE are defined as CLOBs, 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, 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:

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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index