oracle8.1.6 declare v_workflow_key varchar(40); begin v_workflow_key := workflow.create_workflow( workflow_key => '[db_quote $workflow_key]', pretty_name => '[db_quote $workflow_name]', pretty_plural => '[db_quote $workflow_name]', description => '[db_quote $workflow_description]', table_name => '[db_quote $workflow_cases_table]' ); end; declare v_attribute_id acs_attributes.attribute_id%TYPE; begin v_attribute_id := workflow.create_attribute( workflow_key => '[db_quote $workflow_key]', attribute_name => '[db_quote $task($transition_key,loop_attribute_name)]', datatype => 'boolean', pretty_name => '[db_quote "$task($transition_key,loop_question)"]', default_value => '[ad_decode $task($transition_key,loop_answer) "t" "f" "t"]' ); insert into wf_transition_attribute_map (workflow_key, transition_key, attribute_id, sort_order) values ('[db_quote $workflow_key]', '[db_quote $transition_key]', v_attribute_id, 1); end; select constraint_name from user_constraints insert into wf_arcs (workflow_key, transition_key, place_key, direction, guard_callback, guard_custom_arg, guard_description) values ('[db_quote $workflow_key]', '[db_quote $transition_key]', '[db_quote $true_place]', 'out', 'wf_callback.guard_attribute_true', '[db_quote $task($transition_key,loop_attribute_name)]', '[db_quote $task($transition_key,loop_question)]')