Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REPCAT_RGT, 12 of 33
This function creates parameters for a specific deployment template to allow custom data sets to be created at the remote materialized view site. This function is only required when the DBA wants to define a set of template variables before adding any template objects. When objects are added to the template using the CREATE_TEMPLATE_OBJECT
function, any variables in the object DDL are automatically added to the DBA_REPCAT_TEMPLATE_PARMS
view.
The DBA typically uses the ALTER_TEMPLATE_PARM
function to modify the default parameter values and/or prompt strings (see "ALTER_TEMPLATE_PARM Procedure" for more information). The number returned by this function is used internally by Oracle to manage deployment templates.
DBMS_REPCAT_RGT.CREATE_TEMPLATE_PARM ( refresh_template_name IN VARCHAR2, parameter_name IN VARCHAR2, default_parm_value IN CLOB := NULL, prompt_string IN VARCHAR2 := NULL, user_override IN VARCHAR2 := NULL) return NUMBER;
Return Value | Description |
---|---|
<system-generated number> |
System-generated number used internally by Oracle. |
Because the CREATE_TEMPLATE_PARM
function utilizes a CLOB
, you must use the DBMS_LOB
package when using the CREATE_TEMPLATE_PARM
function. The following example illustrates how to use the DBMS_LOB
package with the CREATE_TEMPLATE_PARM
function:
DECLARE
tempstring VARCHAR2(100);
templob CLOB;
a NUMBER;
BEGIN
DBMS_LOB.CREATETEMPORARY(templob, TRUE, DBMS_LOB.SESSION);
tempstring := 'REGION 20';
DBMS_LOB.WRITE(templob, length(tempstring), 1, tempstring);
a := DBMS_REPCAT_RGT.CREATE_TEMPLATE_PARM(
refresh_template_name => 'rgt_personnel',
parameter_name => 'region',
default_parm_value => templob,
prompt_string => 'Enter your region ID:',
user_override => 'Y'
);
DBMS_LOB.FREETEMPORARY(templob);
END;
/
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|