Oracle Workflow Procedures

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

Activity Function Procedures

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: