Ted,
This is standard callable statement JDBC syntax for a
procedure/function. The "?" are assigned the parameter from the
parameterMap in the order declared. Your sample might also work but I
have never tried it :-[ .
Regards,
Mike Fagan
Ted Schrader wrote:
Hi Mike,
I'm simply a spectator on this one, but I'm a bit puzzled about
something in your example. You wrote:
----
<parameterMap id="myParamMap" class="map" >
<parameter property="result" jdbcType="ORACLECURSOR" mode="OUT"/>
<parameter property="userId" jdbcType="NUMERIC" mode="IN"/>
</parameterMap>
<procedure id="mycursorfunction" parameterMap="myParamMap"
resultMap="myResultMap" >
{ ? = call myRefCursorFunction(? ) }
</procedure>
----
Based on your parameter map config (and perhaps some inexperience on
my part), I'd expect your procedure to be:
<procedure id="mycursorfunction" parameterMap="myParamMap"
resultMap="myResultMap" >
{ #result# = call myRefCursorFunction(#userId#) }
</procedure>
Is the usage of "?", (and the curly brackets, for that matter)
specific to the <procedure> tag, or perhaps an Oracle thing?
Thanks,
Ted
