[midPoint] - Execute stored procedure in SQLScript resource

[Ivan Noris]

Hi Rodrigo,

I have shared this comment in our wiki:
https://wiki.evolveum.com/pages/viewpage.action?pageId=17760631 ("Any
Database (ScriptedSQL)". Thank you!


On 09/08/2016 02:38 PM, Rodrigo Yanis wrote:
> originally, we were attempting to perform the call with an incorrect
> syntax: sql.call("*{*? = call STORED_PROCEDURE(?, ?)*}*",[Sql.VARCHAR,
> attributes?.get("pidm")?.get(0), Sql.VARCHAR])
> Proper syntax is: sql.call("? = call STORED_PROCEDURE(?,
> ?)",[Sql.VARCHAR, attributes?.get("pidm")?.get(0), Sql.VARCHAR])
> Note the absence of the enclosures {} in the second line.
> As this might be obvious to most Groovy devs, this gave us quite the
> headache since there's confusing information published regarding this
> method.

-- 
Ivan Noris
Senior Identity Engineer
evolveum.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160909/454f9e06/attachment.htm>