Bind Variable Doesnot exists

[praneeth ram]

Hi all,

I am using Spring HibernateTemplate to call stored procedure. i am getting exception while running it. bellow are the details.

Java Code.

String[] paramNames={"uname","role"};
		Object[] paramValues={"praneeth","admin"};
		ht.findByNamedQueryAndValueBean("myquery",new User());

mapping in xml

<sql-query name="myquery" callable="true" >
          <return alias="usr" class="com.ln.tdmt.dataset.User">
				<return-property column="role" name="role" />
           </return>
       { call  myproc1 ( :uname,:role ) }
      </sql-query>

please suggest me a solution.

[Prasad Krishnegowda]

praneeth ram wrote: i am getting exception while running it.

Java Exception classes are designed, so as to give lot of useful information.
You expect us to make a wild guess, about the exception you are getting?
Please post the exception stack trace..