AnsweredAssumed Answered

When Stored procedure through gel does not work

Question asked by sparc.helpdesk on Nov 19, 2015
Latest reply on Nov 20, 2015 by nick_darlington

When i try to call a stored procedure using gel scripting it does not get executed.

 

Please find below the gel script:

<gel:script xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

    xmlns:core="jelly:core"

    xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"

    xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"

    xmlns:j="jelly:core"

    xmlns:em="jelly:email"

    xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"

    xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"

    xmlns:sql="jelly:sql" xmlns:util="jelly:util" xmlns:x="jelly:xml"

    xmlns:xog="http://www.niku.com/xog"

    xmlns:xsd="http://www.w3.org/2001/XMLSchema"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<gel:setDataSource dbId="Niku"/>

 

 

<sql:update var="call_storedprocedure">

   

                    call iam_data1

                    <gel:log level="INFO">will update all the users mismatched records</gel:log>

      

</sql:update>

</gel:script>

 

Do you have any idea why it does not work because if the same procedure is executed through toad, it works.

So i guess i am doing something wrong in gel scripting. Please let me know your views.

 

Regards,

Jerish

Outcomes