Here's a nice article on stored procedures with Hibernate. This might answer some questions:
Stored Procedures with Hibernate
The worst case scenario is that you simply get back the id of the inserted or queried record. Once you have that id, as was said before, just load that object using either a DAO or the Hibernate Session itself. Then use that loaded POJO and volley it back and forth between your data layer and your web layer.
-Cameron McKenzie