...
The external DB connection to be utilised.
Call
The SQL statement that is Name of the stored procedure to be executed. The call statement uses positional replace args '?'.called.
e.g. call mystatement(?,?,?,?);mystoredproc
Value List
The value List MUST can contain a comma separated list of encoded fields names . The number of fields MUST match the call statements '?' argumentsthat are passed to the stored procedure.
e.g.
${njLeadId}, ${phoneNo}, ${surname}, ${njDispositionAction}
This will result in a SQL call of the form:
call mystoredproc("1","0383208100", "Smith" "Sale")