// 执行用例前，需要先创建 test_cursor 表，并插入一条测试数据，具体代码如下：
    TestUtil.createTable(con, "test_cursor", "c1 int, c2 float, c3 float, c4 text, c5 bigint");
    String insertSQL = TestUtil.insertSQL("test_cursor", "1,2.2,3.3,'test',5");
    TestUtil.execute(insertSQL, con);

    @Test
    public void testSpOutCursor() throws SQLException {
        Statement stmt = null;
        CallableStatement cmt = null;
        try {
            con.setAutoCommit(false);
            // create sp
            String procedureSql = "CREATE OR REPLACE FUNCTION test_refcursor () RETURNS refcursor AS \n" +
                    "\t'declare v_resset refcursor; begin open v_resset for select c1,c2 from test_cursor;\n" +
                    "\treturn v_resset; end;' \n" +
                    "LANGUAGE plpgsql;";
            stmt = con.createStatement();
            stmt.execute(procedureSql);

            // execute sp
            String commandText = "{? = call test_refcursor()}";
            cmt = con.prepareCall(commandText);
            int OracleTypes_CURSOR = -10;
            cmt.registerOutParameter(1, OracleTypes_CURSOR);
            cmt.execute();

            // get result set
            ResultSet rs = (ResultSet) cmt.getObject(1);
            rs.next();
            assertEquals(1, rs.getInt(1));
            assertEquals(2.2d, rs.getDouble(2), 0.0001);
            con.setAutoCommit(true);
        } finally {
            TestUtil.closeQuietly(stmt);
            TestUtil.closeQuietly(cmt);
        }
    }