Project and Portfolio Management Practitioners Forum
cancel

pl/sql in workflow

Highlighted
swpnil
Contributor.

pl/sql in workflow

Can anybody tell me the steps required to use sql commands in the workflow.I want to use a function/sql statement in the execution step.Stepwise explaination would really help.I used an update statement in the execution step earlier but it is giving ora 1007 error.
1 REPLY
Sascha Mohr
Acclaimed Contributor.

Re: pl/sql in workflow

you need to create a new step source in the wf workbench. There, chose pl/sql function as the execution type and put your function call in the execution field like this:

some_package.miracle_function(
p_ID => [REQ.P.KNTA_MASTER_PROJ_REF],
r_ID => [REQ.REQUEST_ID]
)

Here with two example parameters.
hth