The Oracle Workflow item attributes for model apply are as follows:
case_table VARCHAR2(62)
table_1 VARCHAR2(62)
table_n VARCHAR2(62)
case_sql VARCHAR2(32767)
additional_sql_1 VARCHAR2(32767)
additional_sql_n VARCHAR2(32767)
use_table_view_input VARCHAR2(1), 'Y' or 'N'
model_name VARCHAR2(25)
feature_table_name VARCHAR2(30);
apply_result_name VARCHAR2(32)
table_output VARCHAR2(1), 'Y' or 'N'
drop_output VARCHAR2(1)
isDropOutput BOOLEAN (TRUE or FALSE)
USE_TABLE_VIEW_INPUT
takes on the values 'Y'
and 'N'
. 'Y'
indicates that the input is tables or views; 'N'
indicates that the input is SQL. The meaning of the values is described in the following pseudo code:
If USE_TABLE_VIEW_INPUT = 'Y', get the input data from
CASE_TABLE
TABLE_1
TABLE_N
ELSE get the input data from
CASE_SQL
ADDITIONAL_SQL_1
ADDITIONAL_SQL_N
Item attributes that describe tables specify the schema name and the table name in one attribute.
Copyright © 2006, 2008, Oracle. All rights reserved.