Spring +ibatis + oracle存储过程调试

前提:Spring + ibatis + oracle 调试成功

1.普通调用Procedures:

直接在ibatis映射的.xml文件里面 

<parameterMap id="nameid" class="map" >
        <parameter property="name1" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
        <parameter property="outname1" jdbcType="VARCHAR2" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
    <procedure id="test1__try2" parameterMap="nameid">
        <![CDATA[
 {call test1.wap_try(?,?)}
 ]]>
    </procedure>

parameterMap 是带入的参数

2.调用带单个返回值的Function:

用上面方法失败!

使用下面:

  <select id="test1__wap_try" resultClass="com.dataSource.persistency.OracleCall"><![CDATA[
  select test5(#threadTopic#,#userid#,#threadBody#,#parentid#,#categoryname#,#icopicturepath#) as COLUMNS20 from dual
            ]]>
  </select>

返回值名称COLUMNS20 ,test 为Function名,后面是参数

3.调用packages返回单个值或不返回值:

同2

  <select id="test1__wap_try" resultClass="com.dataSource.persistency.OracleCall"><![CDATA[
  select test1.test5(#threadTopic#,#userid#,#threadBody#,#parentid#,#categoryname#,#icopicturepath#) as COLUMNS20 from dual
            ]]>
  </select>
test1为包名,test5为Function名

 4.返回多个值cursor:

目前还不清楚............