Oracle存储过程java.sql.sqlException：无效的列类型：2012(REF_CURSOR)

Question

Oracle 11g、Java 8、OJDBC8/OJDBC7

create or replace procedure foo(employeeId IN number, c OUT SYS_REFCURSOR) AS
BEGIN
    open c for select * from Employee where id = employeeId;
END;

CallableStatement statement = connection.prepareCall("{call foo(?,?)}");
statement.setObject(1, 100);
statement.registerOutParameter(2, java.sql.Types.REF_CURSOR);  // ERROR here
statement.execute();

java.sql.SQLException: Invalid column type: 2012

使用Oracle11g尝试ojdbc7和ojdbc8，出现相同错误。
Oracle11g支持RefCursor。Java8定义了types.ref_cursor。对于11g我应该使用哪个oracle jdbc驱动程序？

Answer 1

我在我的项目中使用了这段代码，它工作得很好

@Override
public ResultSet getCorrespondenceDetail(Long id)  {
    String sql="{call dbpk_person_correspondence.get_report_detail(?,?   )}";
    Connection conn = JDBCUtility.getConnection();
    ResultSet result = null;
    CallableStatement cstmt;
    try {
        cstmt = conn.prepareCall(sql);
    cstmt.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);
    cstmt.setLong(2,id);
    cstmt.execute();
    result = (ResultSet)cstmt.getObject(1);
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return result;
}

项目依赖项：

<dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc6</artifactId>
        <version>11.2.0</version>
</dependency>