Hi All
this is my stored Proc
CREATE OR REPLACE PROCEDURE addNewUser(
UserId1 int,
UserName1 varchar2,
Password1 varchar2,
FirstName1 varchar2,
LastName1 varchar2
) AS
BEGIN
INSERT INTO TBL_USERS_TEMP (userid,username,password,firstname,lastname)
VALUES (UserId1,UserName1,Password1,FirstName1,LastName1);
END;


And this is my .hbm.xml file like this


<class name="AllFiles.Emp" table="EMP_SP">
<id name="id" column="userid">
<generator class="assigned"/>
</id>
<property name="username" column="USERNAME"/>
<property name="password" column="PASSWORD"/>
<property name="firstname" column="FIRSTNAME"/>
<property name="lastname" column="LASTNAME"/>
<sql-insert callable="true">{call addNewUser(:id,:username,:pass,:first,:last)</sql-insert>
</class>

In java class


how to call SP using set the parameters .I use like this But it's giving error

Query query=session.getNamedQuery("addNewEmp");
query.setParameter("id",new Integer(45));
query.setParameter("username","sanjeev");
query.setParameter("pass","sanjeev");
query.setParameter("first","sanjeev");
query.setParameter("last","yadav");
query.executeUpdate();


Please help me out .How to call SP using Sql-insert

Thanks
Sanjeev Thummala

Sorry For Above Mistake


I used Query query=session.getNamedQuery("addNewUser"); //Replace with Named Query "addNewEmp"

Custom sql-insert, update or delete are for session.save(), session.update() and session.delete() operations not for query.



Christophe

Which database are you using?

Hello guys,
sorry for late reply
Iam using Oracle9i


May i know how to set the parameters in stroed Proc when i use only insert stroed Proc.

How to call that Insert stored Prc
will u please give any sample very help full for me