Code: Select all
StoredProcedureQuery storedProcedureQuery = entityManager
.createStoredProcedureQuery("SOME_STORED_PROC")
.registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN)
.registerStoredProcedureParameter(2, Object.class, ParameterMode.REF_CURSOR)
.registerStoredProcedureParameter(3, Object.class, ParameterMode.REF_CURSOR)
.setParameter(1, 123);
storedProcedureQuery.execute();
List firstCursorResultList = storedProcedureQuery.getResultList(); // expected index 2 REF_CURSOR
List secondCursorResultList = storedProcedureQuery.getResultList(); // expected index 3 REF_CURSOR