import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import java.io.Reader;
import java.math.BigDecimal;
import java.util.HashMap;
import java.util.Map;
import java.util.SortedMap;
import javax.servlet.jsp.jstl.sql.Result;

public class RefCursorTest  {
    public RefCursorTest() {
    }
    
    public static void main(String[] args) throws Exception {
        Reader reader = Resources.getResourceAsReader("sql-map-client.xml");
        SqlMapClient client = SqlMapClientBuilder.buildSqlMapClient (reader);
        
        Map parameters = new HashMap(2);
        
        Object result = client.queryForObject("proc1", parameters);
        
        System.out.println("result = " + result);
        System.out.println("parameters.size = " + parameters.size());
        
        Number resultCode = (Number)parameters.get("resultCode");
        System.out.println("resultCode = " + resultCode);
        
        Result results = (Result)parameters.get("result");
        Map[] rows = results.getRows();
        
        for (int i = 0; i < rows.length; i++) {
            System.out.println("rows[" + i + "] = " + rows[i]);
        }
    }

}