I am trying to fetch results from procedure call by the below function
procedurequery.getResultList();
However, I am getting following error:
Hibernate: {call CORE.UAM_REPORT_1(?,?,?,?)}
2024-05-12 18:35:51.752 WARN 10528 --- [nio-8080-exec-2] o.h.e.j.s.SqlExceptionHelper : SQL Error: 0, SQLState: S1093
2024-05-12 18:35:51.753 ERROR 10528 --- [nio-8080-exec-2] o.h.e.j.s.SqlExceptionHelper : The column name group_created_by is not valid.
I am unable to understand from where did group created by showed up ?
SET @SqlQuery = '
SELECT
ulv.id,
ulv.id as user_id,
ulv.employee_Id as EMPLOYEE_ID,
ulv.username as username,
ulv.email as email,
ulv.branch as branch,
ulv.department_name as department_name,
ulv.status as status,
ulv.groups as groups,
NULL as created_date,
NULL as created_by
from CORE.USER_LIST_VIEW ulv
'
EXEC sp_executesql @SqlQuery
I have attached my sql query I am using in procedure above please guide thanks