How to invoke a stored procedure in Hibernate and pass in a parameter?I have { ? = call myservice.TEST_PROC3( ? ) }While I can get stored proc output if there is no input to TEST_PROC3, e.g. call myservice.TEST_PROC3( )I don't know how to code in Java to pass in the parameter required in my case with:call myservice.TEST_PROC3( ? )Can anyone show me how to make such call in Java?Thanks

jyothi_4

 Profile Answers by jyothi_4 Questions by jyothi_4

• Feb 12th, 2011

We can execute stored procedures in hibernate using Native SQL.                       ...

LendingHand

 Profile Answers by LendingHand Questions by LendingHand

• Jun 3rd, 2008

You can declare it as Named queiries in one of your mapping files and give unique name.Call it in your code. Sample code is below.SQLQuery sq = (SQLQuery) session.getNamedQuery("findSearchResults...

Answer Question  Select Best Answer