<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi Rodrigo,</p>
<p>I have shared this comment in our wiki:
<a class="moz-txt-link-freetext" href="https://wiki.evolveum.com/pages/viewpage.action?pageId=17760631">https://wiki.evolveum.com/pages/viewpage.action?pageId=17760631</a>
("Any Database (ScriptedSQL)". Thank you!<br>
</p>
<br>
<div class="moz-cite-prefix">On 09/08/2016 02:38 PM, Rodrigo Yanis
wrote:<br>
</div>
<blockquote
cite="mid:CADu-59EspSkq+xnjdaBL6uU+cgzzOL4n0i5FuD1a=O7DjprPEg@mail.gmail.com"
type="cite">
<div>originally, we were attempting to perform the call with an
incorrect syntax: <span style="font-size:x-small">sql.call("<b>{</b>?
= call STORED_PROCEDURE(?, ?)<b>}</b>",[Sql.VARCHAR,
attributes?.get("pidm")?.get(</span><wbr
style="font-size:x-small"><span style="font-size:x-small">0),
Sql.VARCHAR])</span></div>
<div>Proper syntax is:<span style="font-size:x-small"> </span><span
style="font-size:x-small">sql.call("? = call
STORED_PROCEDURE(?, ?)",[Sql.VARCHAR,
attributes?.get("pidm")?.get(</span><wbr
style="font-size:x-small"><span style="font-size:x-small">0),
Sql.VARCHAR])</span></div>
Note the absence of the enclosures {} in the second line.<br>
As this might be obvious to most Groovy devs, this gave us quite
the headache since there's confusing information published
regarding this method.</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ivan Noris
Senior Identity Engineer
evolveum.com
</pre>
</body>
</html>