Spring ORM HibernateTemplate Mapping Exception

[praneeth ram]

I am using msSqlServer Database. StoredProcedure takes two parameters, and returns one parameter.

Spring HibernateTemplate Code

Here is my Java code:

List l=ht.findByNamedQuery("MY_REF_STORED_PROC1");

Mapping file:

mapping file:
<sql-query name="MY_REF_STORED_PROC1" callable="true">
<return alias="usr" class="SomePOJO">
<return-property name="dSId" column="DSET_ID" />
</return>
exec MY_STORED_PROC1 ( :dSId,:createdUserId )
</sql-query>

I am getting the bellow Exception:

Exception:
org.hibernate.QueryException: Not all named parameters have been set: [dSId, createdUserId] [exec MY_STORED_PROC1 ( :dSId,:createdUserId )]

Please give me a solution for this issue.

Thanks,
Praneeth