SQL,
Run Procees Flow from Command Line or SQL+
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.
|
1 2 |
sqlplus user/pwd@connect_identifier C:oracleproducts10.2.0owb_1owbrtpsqlsqlplus_exec_template.sql <rep_owner> <location process> <flow name> <process flow> <sys params> <custom params> |
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
