How to call stored procedure that returns an array

[Jitesh Sinha]

Hi Folks,

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 -

Entity
    @Table(name = "APPL_USER")
    @Inheritance(strategy = InheritanceType.SINGLE_TABLE)
    @DiscriminatorFormula(value = "SUBSCRIBER_IND")
    @DiscriminatorValue("N")
    @NamedQuery(name = "req.all", query = "select n from Requestor n")
    @org.hibernate.annotations.NamedNativeQuery(name = "SP_APPL_USER", 
query = "call SP_APPL_USER(?, :eid)", callable = true, readOnly = true, resultClass = Requestor.class)

    public class Requestor {

    @Id
        @Column(name = "EMPL_ID")
        public String getEmpid() {
            return empid;
        }

        public void setEmpid(String empid) {
            this.empid = empid;
        }

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?