AnsweredAssumed Answered

Calling procedure using gelScript

Question asked by B3th0z on Dec 15, 2011
Latest reply on Dec 15, 2011 by Chris_Hackett
Found a solution to execute a called procedure using gelScript focused on the MS Sql Server

This procedure can be executed on a desired step of a process.

<gel:script xmlns:core="jelly:core"
xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:jelly="jelly:email"
xmlns:sql="jelly:sql">
<gel:setDataSource dbId="Niku"/>
<sql:update>
<!-- Procedure to be executed and which expects an argument in its invocation -->

EXEC PROCEDURE_SP [color=#f93939]?[color]
<!-- Description of parameter expected by the procedure for its implementation with success -->

<sql:param value="[color=#f93939]nameParam[color]"/>
</sql:update>
</gel:script>

Regard's,

Roberto Mendes - Consultor CA Clarity PPM
[color=#3946f9]robertomendes.ti@gmail.com[color]

Outcomes