DbAdapter provides all kind of operations that helps you interact with the DB.
I saw more than few times, questions, about how to use dynamic parameters when executing the ‘Execute Pure SQL‘ operation.
In the following step I will explain how to do it.
Execute Pure SQL
Inside the Custom SQL sheet, insert your sql query.
Use the ‘#‘ sign to define the parameter.
Where header_id = #header_id
(header_id is the parameter name)
Notice that inside the input element part, a new “parameter” element was defined.
Verify that the type attribute is not null and being defined properly (for example: xs:integer). Otherwise you will get compilation error.
That’s actually it.
Now you can drag an invoke activity and connect it to the new Partner Link.
Drag also an assign activity before the invoke activity.
Within the assign activity you can assign the required parameter.