Code Generator generates activity function procedures that support Oracle Workflow integration. To generate the activity function procedures, you must check Workflow API support when you specify the characteristics of the generated package.
If you generate the activity function procedures, you must install Oracle Workflow. Also, the generated procedures and the data sources used must be both executable and readable by the workflow engine; otherwise, the generated code will not compile. Detailed information about Oracle Workflow is on the Information Integration tab in the Oracle Database Documentation Library 10g Release 2 (10.2).
Note: Oracle Workflow does not ship with Oracle Database 11g Release 1 (11.1).
The activity function procedures are thin wrappers of the generated procedures. All of the workflow procedures have the same predefined signature:
PROCEDURE procedure_name(
item_type IN VARCHAR2,
item_key IN VARCHAR2,
act_id IN NUMBER,
func_mode IN VARCHAR2,
result_out OUT VARCHAR2);
Input data is passed to the activity function calls via activity item attributes.
Each generated call is hard coded to look for certain activity item attributes that
are required for the underlying mining operations. If no item attribute values are
found, default values are used. All of the item attributes are of type TEXT
.
Item attributes that describe tables specify the schema name and the table name in one
attribute. The item attributes depend on the type of activity used to generate the
code:
Copyright © 2006, 2008, Oracle. All rights reserved.