ibatis procedure
Solution 1This is sample mapping for a Stored procedure which return Ref cursor in it's out parameter
<div class="code"><div class="codeContent"><?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" > <sqlMap namespace="KOMUNIKA_REPORT"> <resultMap id="BaseResultMap" class="javaapplication4.StockAreaAndWarehouse" > <result column="PRODUCT_CODE" property="productCode"/> <result column="PRODUCT_NAME" property="productName" /> <result column="INCOMING" property="incoming" /> <result column="UNIT_SOLD" property="unitSold" /> <result column="TOTAL_STOCK" property="totalStock" /> </resultMap> <parameterMap id="resultMap" class="java.util.Map"> <parameter property="result" javaType="java.sql.ResultSet" jdbcType="ORACLECURSOR" mode="OUT"/> </parameterMap> <procedure id="selectStockAreaAndWarehouse" parameterMap="resultMap" resultMap="BaseResultMap" > { call KOMUNIKA.LP_STOCK_AREA_WAREHOUSE(?) } </procedure> </sqlMap>
页:
[1]