postgresql调用功能删除revursersest下一个订单不起作用

Question

- PostgreSQL函数 -

create function test(v_param bigin, OUT mycursor refcursor) returns refcursor
language plpgsql
DECLARE
...
BEGIN
l_stmt := "select * from (select * from mytable order by date_column DESC) as t" --order query execut
..
OPEN mycursor FOR EXECUTE l_stmt
END;

- Java代码 -

Connection conn = sqlSession.getConnection();
PreparedStatement preStmt = conn.prepareStatement("select * from (select * from mytable order by date_column DESC) as t"); //pl/sql function same query
ResultSet resultSet = preStmt.executeQuery();
while(resultSet.next()) {
   /**
      date_column| etc_column
      2022/06/25 | a
      2022/06/24 | b
      2022/06/23 | c
   **/
   System.out.println(resultSet.getObject(11)) //result row ordered
}

- Java Code（呼叫功能结果设置订购问题） -

Connection conn = sqlSession.getConnection();
conn.setAutoCommit(false);
CallableStatement call = conn.prepareCall("{ ? = call test(?) }");
call.registerOutParameter(1, Types.REF_CURSOR);
call.setLong(1, 0L);
call.execute();
ResultSet resultSet = call.getObject(1);
while(resultSet.next()) {
    /**
      date_column| etc_column
      2022/06/24 | b
      2022/06/25 | a
      2022/06/23 | c
   **/
   System.out.println(resultSet.getObject(11)) //result row not ordered
}

- 问题。--

通过执行排序查询来获得光标时无法保证订单？