This procedure is a wrapper for the commonly used apply procedure that applies a model where the input and the output are both tables or views.
PROCEDURE apply_procedure_name(
case_table IN VARCHAR2 DEFAULT activity default,
table_1 IN VARCHAR2 DEFAULT activity_default,
table_n IN VARCHAR2 DEFAULT activity_default,
model_name IN VARCHAR2 DEFAULT activity_default,
feature_table IN VARCHAR2 DEFAULT activity_default,
apply_result_name IN VARCHAR2 DEFAULT activity_default,
table_output IN BOOLEAN DEFAULT TRUE,
drop_output IN BOOLEAN DEFAULT user_defined);
The procedure has two kinds of defaults:
activity_default
: The default is the value specified in the activity from which code was generated. For example, model_name
is by default the name specified in the activity.user_defined
: The default is the value specified when the code is generated.Table 1 Batch Apply with Input and Output Tables or Views Parameters
Parameter | Description |
---|---|
apply_procedure_name_TT |
The name specified for the procedure when the code was generated with the _TT suffix added. |
case_table |
The name of the case table (or view). The name is in the form schema_name.table_name . |
table_1 |
The name of the first additional table. The name is in the form schema_name.table_name . This parameter is optional. |
table_n |
The name of the n-th additional table. The name is in the form schema_name.table_name . This parameter is optional. |
model_name |
The name of the model being applied. |
feature_table |
Feature ID to text mapping table generated by the text transform. Can be used to translate model detail output containing columns affected by a text transformation. |
apply_result_name |
The name of apply result table or view created by the procedure. The name is in the form schema_name.table_name . |
table_output |
The default value TRUE indicates that the output of the procedure is a table or view. |
drop_output |
A flag indicating whether to drop the output if it already exists. The value of this flag was specified when the code was generated. |
This procedure includes all necessary data preparation, data transformations, and apply settings. The procedure creates an apply output table or view. If the output already exists and drop_output
is set to FALSE
, the procedure will raise an exception to the caller and exit.
The feature table is the one generated by the Build procedure for the model that is being applied.
You can supply a feature_table
name different from the default name, but you must supply the same name in
both Build and Apply procedures.
Copyright © 2006, 2008, Oracle. All rights reserved.