Currently facing an issue with hibernate 6 where nvarchar(max) gets truncated at around ~7500 characters. It was solved in the older version of Hibernate by using NTextType.class as the type in registerStoredProcedureParameter. Thanks
Solved. Used StandardBasicTypes.NTEXT as the identifier instead.