Java用Maybtis调用Oracle的存储过程（返回游标）

例如连接如下数据库

数据库连接字符串：
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.220.4.156)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DATACENTER)
    )
  )

表名

  datadba.unv_he_di_pkg.unv_get_prod_items(p_start_date in date,
                               p_end_date   in date,
                               p_result     out cur_data);--游标

# 配置 oracle
        oracle:
          url: jdbc:oracle:thin:@10.220.4.156:1521/DATACENTER
          username: RD_HE
          password: rdpehe*123987.
          driver-class-name: oracle.jdbc.driver.OracleDriver

        
            com.oracle
            ojdbc6
            11.2.0.1.0
        
        
            com.oracle.database.jdbc
            ojdbc8
        

xml类


    
        {call datadba.unv_he_di_pkg.unv_get_prod_items(
                        #{p_start_date,mode=IN,jdbcType=DATE},
                        #{p_end_date,mode=IN,jdbcType=DATE},
                        #{p_result,mode=OUT,jdbcType=CURSOR,javaType=ResultSet,resultMap = CodeSetByTimeMap}
        )}
    

Mapper层


    ArrayList selectCodeSetByTime(HashMap map);

service层

ArrayList selectCodeSetByTime(HashMap map);

Impl层
@Override
    @DS("oracle")
    public ArrayList selectCodeSetByTime(HashMap map) {
        return storedProcedureMapper.selectCodeSetByTime(map);
    }

		HashMap map = new HashMap<>();
		Date date1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.sss").parse("2022-04-19 00:00:00.000");
		Date date2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.sss").parse("2022-04-22 00:00:00.000"); map.put("p_start_date", date1);
		map.put("p_end_date", date2);
		storedProcedureService.selectCodeSetByTime(map);
		List o = (List) map.get("p_result");

        后续根据对应的实体类就可以获得对用的数据