Build Association Model Procedure

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.

Syntax

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);

Parameters and Defaults

The procedure has two kinds of defaults:

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.

Usage Notes

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.