AnsweredAssumed Answered

GEL Process Started but not doing anything and not finishing

Question asked by matpj on May 9, 2011
Latest reply on May 13, 2011 by Chris_Hackett
Hi all,

I have a rather simple GEL script that reads data from the current object instance and then calls a stored procedure in our Oracle database.
When I add a row to the object and then run a process from it, the Process starts, but never gets any further than that.

here is the script:
<gel:script xmlns:core="jelly:core" 
xmlns:define="jelly:define" 
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" 
xmlns:sql="jelly:sql">

<gel:setDataSource dbId="niku"/>
<sql:query var="result">

SELECT * FROM odf_ca_dst_gl_post
WHERE id = ${gel_objectInstanceId}

</sql:query>


<gel:log level="INFO" message="Distribution query ran ok. Running SP..."/>

<gel:log level="INFO" message="call P_GLPOST('${result.rows[0].DST_GL_ENTITY}', '${result.rows[0].DST_GL_TRANSTYPE}', '${result.rows[0].DST_GL_START_DATE}', '${result.rows[0].DST_GL_END_DATE}', '${result.rows[0].DST_ACCOUNT_PERIOD}', '${result.rows[0].DST_GL_INC_INT}','${result.rows[0].DST_GL_CHG_ONLY}','${result.rows[0].DST_GL_TRIAL}','${result.rows[0].DST_GL_POST_RPT}','${result.rows[0].DST_TESTERFIELD}')"/>

<sql:update escapeText="false">
call P_GLPOST('${result.rows[0].DST_GL_ENTITY}', '${result.rows[0].DST_GL_TRANSTYPE}', '${result.rows[0].DST_GL_START_DATE}', '${result.rows[0].DST_GL_END_DATE}', '${result.rows[0].DST_ACCOUNT_PERIOD}', '${result.rows[0].DST_GL_INC_INT}','${result.rows[0].DST_GL_CHG_ONLY}','${result.rows[0].DST_GL_TRIAL}','${result.rows[0].DST_GL_POST_RPT}','${result.rows[0].DST_TESTERFIELD}')
</sql:update>
</gel:script>
I have output the stored procedure call as a gel message, which works fine if I then paste it into my query editor.
Can anybody suggest something I am doing fundamentally wrong here....


thanks in advance,
Matt

Outcomes