For the below code
procedurequery = entityManager.createNamedStoredProcedureQuery("UserManagementReportModel.generate");
procedurequery.setParameter("CREATED_START_DATE", formattedStartDate);
procedurequery.setParameter("CREATED_END_DATE", formattedEndDate);
procedurequery.setParameter("USERS_LIST", parameters.get("usersList"));
procedurequery.setParameter("USER_GROUPS_LIST", parameters.get("userGroupsList"));
procedurequery.setParameter("ROLES_LIST", parameters.get("rolesList"));
procedurequery.setParameter("BRANCHES", parameters.get("branches"));
procedurequery.execute();
I am getting following error :
Hibernate: {call C.REPORT(?,?,?,?,?,?)}
2024-05-09 02:58:41.597 WARN 9936 --- [nio-8080-exec-1] o.h.e.j.s.SqlExceptionHelper : SQL Error: 102, SQLState: S0001
2024-05-09 02:58:41.599 ERROR 9936 --- [nio-8080-exec-1] o.h.e.j.s.SqlExceptionHelper : Incorrect syntax near ':'.
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Error calling CallableStatement.getMoreResults
Unable to figure out where the error is as procedure when called directly works fine