how we can call stored procedure in hibernate?

[raminaa niilian]

Hi
Thank you for reading my post
can some one explain me how we can call and use result of an stored procedure using hibernate?

thanks

[Mark Spritzler]

Well, I am going to forward you off to the hibernate.org website where in the FAQ they have really good stuff for stored procedures.

There are two caveats to stored procedures.

1. You can only have one out parameter,
2. and it must be the first parameter, the out cannot be the second, third or more paramater.

As stored procedures you will basically define a mpaaing of a named-query in you config file. You can also configure your insert, update and deletes to call triggers too.

Mark