calling of stored procedure with out parater in hibernate?

[Manish Shinde]

HI All,

i m facing some problem while calling simple oracle stored procedure from hibernate.

Following is the procedure & code.

1)

CREATE OR REPLACE PROCEDURE getSum(num3 OUT NUMBER,num1 IN NUMBER,num2 IN NUMBER)
IS
BEGIN
num3 := num1 + num2;
END;
/

2)test.hbm.xml (here i m calling procedure)

 <sql-query name="getSum"  callable="true">
                {?=call getSum(:val1, :val2 ) }
    </sql-query>

or i have tried another way

 <sql-query name="getSum"  callable="true">
                {call getSum(?,:val1, :val2 ) }
    </sql-query>

3) Test.java

import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class test {

    public static void main(String[] args) {
        try {
            Configuration cfg = new Configuration();
            cfg.configure();
            SessionFactory factory = cfg.buildSessionFactory();
            Session s = factory.openSession();

            Query q = s.getNamedQuery("test");

            Object result = q.uniqueResult();
            System.out.println(result);

            Query q1 = s.getNamedQuery("getSum");
            q1.setInteger("val1", 5);
            q1.setInteger("val2", 5);

            Object result1 = q1.uniqueResult();
            System.out.println(result1);
            s.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

here my procedure is getting called but it is giving pl/sql error : wrong number or types of arguments in call to 'GETSUM'
i tested this procedure on oracle editor it is working fine but while running from the hibernate it is giving error .

what am i missing?

Thanks In Advance.

Regards,
Manish