Hi Dave,
May I ask question on this yours very old post?
I'm currently "struggling" with the task that I need to get "next_value" for next project ID that I'll XOG in to Clarity.
I've searched all posts on this topic but still can't execute SP from GEL properly. I've also found that out parameter "next_value"
can be obtained from some table, so only thing I need is to execute SP from GEL. I've tried EXEC or CALL NIKU.CMN_AUTONUM_GET_NEXT_SP
in <sql:update> and <sql:query> tags, but no luck.
Could you please be so kind to share your piece of code please? (We are on Oracle).
Thank you very much,
Matej