The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

pl/sql in workflow

Highlighted
swpnil
Occasional Advisor

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
Esteemed 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
//Add this to "OnDomLoad" event