Thanks a lot for the information!!
On 6/14/06, Jeff Butler <
[EMAIL PROTECTED]> wrote:
Two ways to do it.First way...<parameterMap id="myParameterMap" class="com.MyClass"><parameter property="output1" jdbcType="INTEGER" mode="OUT" /><parameter property="requestId" jdbcType="INTEGER" mode="IN" /><parameter property="output2" jdbcType="VARCHAR" mode="OUT" /></parameterMap><procedure id="myProc" parameterMap="myParameterMap">
{?=call test_request.mySP(?,?)}</procedure>
Second way...<procedure id="myProc" parameterClass="com.MyClass">
{#output1,jdbcType=INTEGER,mode=OUT#=call test_request.mySP( #requestId,jdbcType=INTEGER,mode=IN#,#output2,jdbcType=VARCHAR,mode=OUT#)}</procedure>
The first way has been documented for some time. The second way has been available for some time, but only recently documented (see the latest PDF in SVN).Jeff Butler
On 6/14/06, Debasish Dutta Roy <[EMAIL PROTECTED] > wrote:Can you please give me your example. That would be really helpful.
On 6/14/06, Larry Meadors <[EMAIL PROTECTED] > wrote:I have had success using a external resultmap and then using "?"
instead of #property# in the mapped statement.
Larry
On 6/14/06, Debasish Dutta Roy <[EMAIL PROTECTED]> wrote:
> Dear all
> The documentation of SP is so bad it really creates loads of downtime.
>
> Can anyone give me a detailed example of using Stored Procedure. My
> requirements...
>
> 1. The SP looks like
>
> {?=call test_request.mySP(?,?)}
>
> where 1 = Registered out parameter type INT, 2=In Parameter type INT, 3=Out
> Parameter type VARCHAR
>
> I have an object that contains 3 member variables. So in the xml my SP looks
> like
>
> {#output1#=call test_request.mySP(#requestId#, #output2#)}
>
> Cannot get to work. Trying out several combinations stupidly.
>
> Has anyone done like this? Urgent...
>
