I am not sure I understand. Are you trying to call a procedure with a
single OUT parameter?
If so, the syntax should be:
<procedure id="BlahOut" parameterMap="BlahParm"
resultClass="java.util.HashMap" >
{ call blah(?) }
</procedure>
and the parameter map should look like this:
<parameterMap id="BlahParm" class="java.util.Map">
<parameter property="a" mode="OUT" />
</parameterMap>
Larry
On 6/26/05, Bing Qiao <[EMAIL PROTECTED]> wrote:
> Hi Clinton
>
> I tried something like this:
> {? = call procedure_name}
>
> The ? is defined as an out parameter mapped onto a member (String,
> int) of a HashMap object (I tried a javabean later as well) in the
> parameter map.
>
> I didn't succeed with that.
>
> I tried to use inline parameter map too:
> {#value:OUT# = call procedure_name}
> by passing an Integer as parameter to queryForObject or other sqlmap methods.
>
> It didn't work either.
>
> Could you please advice what I need to do?
>
> I'm new to java programming. I don't have much JDBC experience
> and sqlmap is the only database access tool I ever used in a
> production project which I inherited from other developers.
>
> I appreciate you help, thanks very much!
>
> On 6/25/05, Clinton Begin <[EMAIL PROTECTED]> wrote:
> > Hi Bing,
> >
> > How do you get the return code using JDBC?
> >
> > Cheers,
> > Clinton
> >
> >
> > On 6/23/05, Bing Qiao <[EMAIL PROTECTED]> wrote:
> > > Help please!
> > >
> > > I have had several talks with our DBA who is so skeptical of iBATIS
> > > and vow to force us to go back to jdbc. One of his arguments is that
> > > the return code from stored procedure can not be retrieved by sqlmap.
> > >
> > > I tried all I could but no luck till now. Any help please!
> > >
> > > Thanks a lot!
> > >
> > > On 6/23/05, Bing Qiao <[EMAIL PROTECTED]> wrote:
> > > > Hi,
> > > >
> > > > What do I need to add to the sqlmap to get the return value (for
> > > > example, return -9) of stored procedure?
> > > >
> > > >
> > > > Thanks very much!
> > > >
> > > > bqiao
> > > >
> > >
> >
> >
>
