ibatis procedure

<?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>

CREATE OR REPLACE PROCEDURE KOMUNIKA.LP_STOCK_AREA_WAREHOUSE(
    RESULT_CURSOR out TYPES.ref_cursor) as
    BEGIN
    OPEN RESULT_CURSOR FOR select PRODUCT_CODE, PRODUCT_NAME, INCOMING, UNIT_SOLD, TOTAL_STOCK
    from KOMUNIKA.STOCK_AREA_AND_WAREHOUSE ;
    END LP_STOCK_AREA_WAREHOUSE;

CREATE OR REPLACE PACKAGE KOMUNIKA.Types
    AS
    TYPE ref_cursor IS REF CURSOR;
    END;

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
    <sqlMapConfig>
    <settings useStatementNamespaces="true" classInfoCacheEnabled="true" />
    <transactionManager type="JDBC" >
    <dataSource type="SIMPLE">
    <property name="JDBC.Driver" value="oracle.jdbc.OracleDriver"/>
    <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
    <property name="JDBC.Username" value="YOUUSERHERE"/>
    <property name="JDBC.Password" value="YOURPASSWORDHERE"/>
    <property name="JDBC.DefaultAutoCommit" value="true" />
    </dataSource>
    </transactionManager>
    <sqlMap resource="javaapplication4/KOMUNIKA_REPORT_SqlMap.xml" />
    </sqlMapConfig>

package javaapplication4;
    
    import com.ibatis.common.resources.Resources;
    import com.ibatis.sqlmap.client.SqlMapClient;
    import com.ibatis.sqlmap.client.SqlMapClientBuilder;
    import java.io.Reader;
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;
    
    /**
    *
    * @author ifnu<mailto:ifnubima@gmail.com>
    */
    public class Main {
    public static void main(String[] args) throws Exception {
    String resource;
    Reader reader;
    List list;
    SqlMapClient sqlMap;
    resource = "javaapplication4/ibatis.xml";
    reader = Resources.getResourceAsReader (resource);
    sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
    Map map = new HashMap();
    // use queryForList because the procedure map defines a resultmap
            // for the statement
            list = sqlMap.queryForList("KOMUNIKA_REPORT.selectStockAreaAndWarehouse", map);
    System.out.println(list);
    }
    }

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
    
    <sqlMap>
    
    <typeAlias alias="Employee" type="test.Employee" />
    
    <resultMap id="employee-map" class="Employee">
    <result property="name" column="ENAME" />
    <result property="employeeNumber" column="EMPNO" />
    <result property="departmentNumber" column="DEPTNO" />
    </resultMap>
    
    <parameterMap id="single-rs" class="map" >
    <parameter property="in1" jdbcType="int" javaType="java.lang.Integer" mode="IN"/>
    <parameter property="output1" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT"/>
    </parameterMap>
    
    <procedure id="GetSingleEmpRs" parameterMap="single-rs" resultMap="employee-map">
    { call scott.example.GetSingleEmpRS(?, ?) }
    </procedure>
    
    <parameterMap id="double-rs" class="map" >
    <parameter property="in1" jdbcType="int" javaType="java.lang.Integer" mode="IN"/>
    <parameter property="output1" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="employee-map" />
    <parameter property="output2" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="employee-map" />
    </parameterMap>
    
    <procedure id="GetDoubleEmpRs" parameterMap="double-rs" >
    { call scott.example.GetDoubleEmpRS(?, ?, ?) }
    </procedure>
    </sqlMap>

package test;
    import java.io.Reader;
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;
    
    import com.ibatis.common.resources.Resources;
    import com.ibatis.sqlmap.client.SqlMapClient;
    import com.ibatis.sqlmap.client.SqlMapClientBuilder;
    
    public class Main {
    
    
    public static void main(String arg[]) throws Exception {
    String resource;
    Reader reader;
    List list;
    SqlMapClient sqlMap;
    resource = "test/SqlMapConfig.xml";
    reader = Resources.getResourceAsReader (resource);
    sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
    Map map = new HashMap();
    map.put("in1", new Integer(10));
    // use queryForList because the procedure map defines a resultmap
    	        // for the statement
    	        list = sqlMap.queryForList("GetSingleEmpRs", map);
    
    System.out.println("--------------------");
    System.out.println( list );
    System.out.println("--------------------");
    
    map = new HashMap();
    map.put("in1", new Integer(10));
    // use queryForObject because the procedure map does not define a
    	        // result map for the statement
    	        sqlMap.queryForObject("GetDoubleEmpRs", map);
    
    System.out.println("--------------------");
    System.out.println( map.get("output1"));
    System.out.println( map.get("output2"));
    System.out.println("--------------------");
    
    
    }
    }