Exception in thread "main" java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support resultsets via stored procedures.
When we are calling stored procedure with ref cursor we are getting this error. StoredProcedureQuery query = em.createStoredProcedureQuery("test_cur1"); query.registerStoredProcedureParameter("test", String.class, ParameterMode.IN); query.registerStoredProcedureParameter("out_cur", void.class, ParameterMode.REF_CURSOR); query.setParameter("test", "abcd"); boolean execute = query.execute(); List employees = (List) query.getOutputParameterValue("out_cur");
Thanks
|