How to use stored procedure in ibatis? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 8 years ago.

开发者_StackOverflow中文版 Improve this question

How to use stored procedure in ibatis?

---

Like this:

<procedure id="getUserEmail"
  parameterClass="java.lang.String" resultClass="java.lang.String">
    {call SP_getUserEmail(#username#)}
</procedure>

---

It should be something like this in mybatis 3:

<update id="myProcCall" parameterType="map" statementType="CALLABLE">
    {    
        call MY_PROC(#{param1, javaType=String, jdbcType=VARCHAR, 
         mode=IN},#{param2, javaType=String, jdbcType=VARCHAR, 
         mode=IN)
     }
</update>