Quick Search:
 The Oracle PL/SQL USER_REPCAT_USER_PARM_VALUES View      [Return To Index] Jump to:  


In Oracle, the static dictionary view USER_REPCAT_USER_PARM_VALUES maintains the template parameters for all deployment templates contained in the database which are owned by the current user. The view is populated when a template, which is accessible by the current user, is instantiated. The structure of the dictionary view is shown below.

REFRESH_TEMPLATE_NAME [VARCHAR2(30)] - Deployment template name
OWNER [VARCHAR2(30)] - Deployment template owner
REFRESH_GROUP_NAME [VARCHAR2(30)] - Refresh group associated during the instantiation process.
TEMPATE_COMMENT [VARCHAR2(2000)] - User comments.
PUBLIC_TEMPLATE [VARCHAR2(1)] - Determines whether the template is public or private
PARAMETER_NAME [VARCHAR2(30)] - Parameter name
DEFAULT_PARM_VALUE [ CLOB(4000)] - Default value for the parameter.
PROMPT_STRING [ VARCHAR2(2000)] - The prompt string for the parameter.
PARM_VALUE [ CLOB(4000)] - For a user, a value can be defined for the parameter in this column
USER_NAME [VARCHAR2(30)] - Username for whom the above value (PARM_VALUE) is defined

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org