You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Dave Rodenbaugh <dr...@WILDBLUECORP.COM> on 2007/01/26 00:50:55 UTC
Calling a single-param SP
Hi everyone,
New question....
If I have a stored proc that takes a single parameter...is this the
right way to call it in the SQL Map XML?
<parameterMap id='paramFooProc' class='java.lang.String'>
<parameter property='singleParamName' jdbcType='VARCHAR'
javaType='java.lang.String' mode='IN'/>
</parameterMap>
<procedure id='fooProc' parameterMap='paramFooProc'>
{call OWNER.APP.SP_NAME(?)}
</procedure>
or should I be using a parameterClass='java.lang.String' instead of the
parameterMap in the procedure tag?
Confused,
-D
Re: Calling a single-param SP
Posted by Nathan Maves <na...@gmail.com>.
looks correct to me. give it a go
On 1/26/07, Brandon Goodin <br...@gmail.com> wrote:
>
> did you try it?
>
> On 1/25/07, Dave Rodenbaugh <dr...@wildbluecorp.com> wrote:
> >
> > Hi everyone,
> >
> > New question....
> >
> > If I have a stored proc that takes a single parameter...is this the
> > right way to call it in the SQL Map XML?
> >
> >
> > <parameterMap id='paramFooProc' class='java.lang.String'>
> >
> > <parameter property='singleParamName' jdbcType='VARCHAR' javaType='
> > java.lang.String' mode='IN'/>
> >
> > </parameterMap>
> >
> > <procedure id='fooProc' parameterMap ='paramFooProc'>
> >
> > {call OWNER.APP.SP_NAME(?)}
> >
> > </procedure>
> >
> > or should I be using a parameterClass='java.lang.String' instead of the
> > parameterMap in the procedure tag?
> >
> > Confused,
> >
> > -D
> >
>
>
Re: Calling a single-param SP
Posted by Brandon Goodin <br...@gmail.com>.
did you try it?
On 1/25/07, Dave Rodenbaugh <dr...@wildbluecorp.com> wrote:
>
> Hi everyone,
>
> New question....
>
> If I have a stored proc that takes a single parameter...is this the right
> way to call it in the SQL Map XML?
>
>
> <parameterMap id='paramFooProc' class='java.lang.String'>
>
> <parameter property='singleParamName' jdbcType='VARCHAR' javaType='
> java.lang.String' mode='IN'/>
>
> </parameterMap>
>
> <procedure id='fooProc' parameterMap='paramFooProc'>
>
> {call OWNER.APP.SP_NAME(?)}
>
> </procedure>
>
> or should I be using a parameterClass='java.lang.String' instead of the
> parameterMap in the procedure tag?
>
> Confused,
>
> -D
>