The Build Association Model procedure is generated from an activity that successfully builds an association model. All parameters are initialized to the default values that were used by the build activity. If you use input parameters that are not the default parameters, you must ensure the new data is compatible with the original data that was used by the activity.
PROCEDURE assoc_build_procedure_name(
transactional_table IN VARCHAR2 DEFAULT activity_default,
model_name IN VARCHAR2 DEFAULT activity_default,
drop_model 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 Association Model Build Procedure Parameters
Parameter | Description |
---|---|
assoc_build_procedure_name |
The name specified for the procedure when the code was generated. |
transactional_table |
The name of the table used to build the model. The table must be in transactional format. The name is in the form schema_name.table_name . |
model_name |
The name of the model created by the procedure; 25 or fewer characters in length. |
drop_model |
A flag indicating whether to drop the model 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 model build settings. The procedure creates a model. If the model already exists and drop_model
is set to FALSE
, the procedure will raise an exception to the caller and exit.
Copyright © 2006, 2008, Oracle. All rights reserved.