Hi All,


I am using Hibernate + Spring. I wrote a oracle stored Pocedure that retireves the rows from the DEPT table based on some condition like where
deptno is 10 something like this,

Proc name is : GET_DEPT_PROCEDURE

I am calling this procedure thru named query as follows...

<sql-query name="name3" callable="true">
<return alias="DeptObj" class="secondEx.DeptObj">
{ call GET_DEPT_PROCEDURE(?,:dnumber) }
</sql-query>

where dnumber is the variable name that has to be set as where condition in Implementation class..

How to set the parameters to the stored procedure and call....I am using

getHibernateTemplate()..

If it has no input condition it will work with,

getHibernateTemplate().findByNamedQuery("name3");

Problem is with the input parameters.. Pls help me ....


Thnx in advance..

Hi,

I have solved this problem...I foun dthe following statement working..

Query f = getHibernateTemplate().getSessionFactory().openSession().getNamedQuery("name3").setParameter("h", new Integer(299)) .setParameter("dnumber","newDept") ;
return (ArrayList)f.list();