ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Fagan <mfa...@tde.com>
Subject Re: calling stored functions
Date Wed, 01 Feb 2006 17:53:06 GMT
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
>
>   


Mime
View raw message