The following is from Hibernate 3 official doc:
"Hibernate 3 introduces support for queries via stored procedures and functions. Most of the following documentation is equivalent for both. The stored procedure/function must return a resultset ".

Does that mean: You can't use those stored procedures which don't return a resultset, like the Stored procedures to perform Update/Insert/delete?

thanks!

No, that's specifically for queries involving stored procedures. If you're using stored procedures in <sql-instert> or <sql-update> elements, then they don't return result sets.

Thanks tenwit!

According to the example provided by Hibernate:

<class name="Person">
<id name="id">
<generator class="increment"/>
</id>
<property name="name" not-null="true"/>
<sql-insert callable="true">{call createPerson (?, ?)}</sql-insert>
<sql-delete callable="true">{? = call deletePerson (?)}</sql-delete>
<sql-update callable="true">{? = call updatePerson (?, ?)}</sql-update>
</class>

Does that mean those CUD Stored Procedures have to be attached with one class?

I'm not sure what you mean. They have to be called with all the correct parameters, is that what you're asking? The paragraph in the ref docs just below that example code tells you how to get the parameter order.