I have searched a lot on internet trying to find sample code for my requirement.The closest solution to my problem that I can find is -
The part that bothers me is the resultClass attribute inside org.hibernate.annotations.NamedNativeQuery annotation.I don't have any class for this attribute since my stored procedure is going to return 2 dimensional array.Is it even possible to call this kind of stored procedure from hibernate code?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: How to call stored procedure that returns an array