Run Procees Flow from Command Line or SQL+

Uli Bethke Oracle Warehouse Builder

You can run a process flow from the command line. This is useful if you want to call a process flow from another application, e.g. if you want to use a 3rd party scheduler like AT or Cron etc. or if you want to script the execution of your process flows.

You need to call the sqlplus_exec_template.sql from sqlplus and pass five parameters to the script as in the example above:

rep_owner: repository owner
location: for a process flow this is the location for the Oracle Workflow Manager as defined in the OWB Design Center
process flow: Just pass in PROCESSFLOW as arg
name process flow: The name of your process flow
sys params: "," if you don't have any
custom params: P_ENABLE_TRACE=0 as an example