How to use storedProcedure in Hibernate 3

[Anu satya]

Hi,
I am new to Hibernate.
I have an application where stored procedure needs to be called from Hibernate 3 using
NamedQuery as given below. I am using oracle as DB. my stored procedure Name is: 'storedprocedure_test'

java code:
Query query = session.getNamedQuery("stored_procedure Name as configured in hbm.xml ");

hbm.xml file
<hibernate-mapping>

<class name="com.a.b.c.Employee" table="Employ">
      	<id name="ID" column="ID"/>
		<property name="firstName" column="fName"/>
		<property name="lastName" column="lname"/>
		<property name="address" column="address"/>
		
    </class>
<sql-query name="stored_Procedure" callable="true" >
<return alias="emclass" class="com.a.b.c.employer"/>

 
<return-property name="firstName" column="firstName"></return-property>
<return-property name="lastName" column="lastName"></return-property>
<return-property name="address" column="address"></return-property>

</return>  
{ call storedprocedure_test()}

</sql-query>

</hibernate-mapping>

My question:
1. I am getting error as:

org.hibernate.HibernateException: Errors in named queries: stored_procedure
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:365)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)

but, when i run that Stored procedure in DB, i am getting proper result.
Can anyone please help me how to execute the NamedQuery ?

my stored procedure is having two input parameters and two output parameters

Any one please help. I searched a lot in google but, no luck.

[K. Tsang]

I'm sure there are lots of resources on Google about calling store proc in Hibernate. Below is one for MySQL. The idea is the same for any other DB.
Hibernate calling MySQL store proc

[Anu satya]

Thanks Tsang,
I have already tried all the google options.
But, struck at one point. That is:

1. For Hibernate, Is it possible to call a stored Procedure which accepts 2 input parameters and 2 output parameteres?

Can you please help me with this?

[jatan bhavsar]

Hi ,

Hibernate dosent suuport multiple output parameters refer this thread.
and multiple input parameters can be pass to stored procedure.

Regards
Jatan